How to Run Form View in Web-serverhttp://forums.asp.net/t/1771119.aspx/1?How+to+Run+Form+View+in+Web+serverTue, 21 Feb 2012 00:44:21 -050017711194839301http://forums.asp.net/p/1771119/4839301.aspx/1?How+to+Run+Form+View+in+Web+serverHow to Run Form View in Web-server <pre class="prettyprint">&lt;asp:FormView ID=&quot;FormView1&quot; runat=&quot;server&quot; AllowPaging=&quot;True&quot; BackColor=&quot;White&quot; BorderColor=&quot;#999999&quot; BorderStyle=&quot;None&quot; BorderWidth=&quot;1px&quot; Caption=&quot;Add/Edit/Delete A Event&quot; CellPadding=&quot;3&quot; DataKeyNames=&quot;id&quot; DataSourceID=&quot;edcalls&quot; EmptyDataText=&quot;Please Enter some data&quot; GridLines=&quot;Vertical&quot; HeaderText=&quot;Event Detail&quot; Width=&quot;406px&quot; Height=&quot;208px&quot;&gt; &lt;EditItemTemplate&gt; id: &lt;asp:Label ID=&quot;idLabel1&quot; runat=&quot;server&quot; Text='&lt;%# Eval(&quot;id&quot;) %&gt;' /&gt; &lt;br /&gt; event_name: &lt;asp:TextBox ID=&quot;event_nameTextBox&quot; runat=&quot;server&quot; Text='&lt;%# Bind(&quot;event_name&quot;) %&gt;' /&gt; &lt;br /&gt; &lt;asp:LinkButton ID=&quot;UpdateButton&quot; runat=&quot;server&quot; CausesValidation=&quot;True&quot; CommandName=&quot;Update&quot; Text=&quot;Update&quot; /&gt; &amp;nbsp;&lt;asp:LinkButton ID=&quot;UpdateCancelButton&quot; runat=&quot;server&quot; CausesValidation=&quot;False&quot; CommandName=&quot;Cancel&quot; Text=&quot;Cancel&quot; /&gt; &lt;/EditItemTemplate&gt; &lt;EditRowStyle BackColor=&quot;#008A8C&quot; Font-Bold=&quot;True&quot; ForeColor=&quot;White&quot; /&gt; &lt;FooterStyle BackColor=&quot;#CCCCCC&quot; ForeColor=&quot;Black&quot; /&gt; &lt;HeaderStyle BackColor=&quot;#000084&quot; Font-Bold=&quot;True&quot; ForeColor=&quot;White&quot; /&gt; &lt;InsertItemTemplate&gt; event_name: &lt;asp:TextBox ID=&quot;event_nameTextBox&quot; runat=&quot;server&quot; Text='&lt;%# Bind(&quot;event_name&quot;) %&gt;' /&gt; &lt;br /&gt; &lt;asp:LinkButton ID=&quot;InsertButton&quot; runat=&quot;server&quot; CausesValidation=&quot;True&quot; CommandName=&quot;Insert&quot; Text=&quot;Insert&quot; /&gt; &amp;nbsp;&lt;asp:LinkButton ID=&quot;InsertCancelButton&quot; runat=&quot;server&quot; CausesValidation=&quot;False&quot; CommandName=&quot;Cancel&quot; Text=&quot;Cancel&quot; /&gt; &lt;/InsertItemTemplate&gt; &lt;ItemTemplate&gt; id: &lt;asp:Label ID=&quot;idLabel&quot; runat=&quot;server&quot; Text='&lt;%# Eval(&quot;id&quot;) %&gt;' /&gt; &lt;br /&gt; event_name: &lt;asp:Label ID=&quot;event_nameLabel&quot; runat=&quot;server&quot; Text='&lt;%# Bind(&quot;event_name&quot;) %&gt;' /&gt; &lt;br /&gt; &lt;asp:LinkButton ID=&quot;EditButton&quot; runat=&quot;server&quot; CausesValidation=&quot;False&quot; CommandName=&quot;Edit&quot; Text=&quot;Edit&quot; /&gt; &amp;nbsp;&lt;asp:LinkButton ID=&quot;DeleteButton&quot; runat=&quot;server&quot; CausesValidation=&quot;False&quot; CommandName=&quot;Delete&quot; Text=&quot;Delete&quot; /&gt; &amp;nbsp;&lt;asp:LinkButton ID=&quot;NewButton&quot; runat=&quot;server&quot; CausesValidation=&quot;False&quot; CommandName=&quot;New&quot; Text=&quot;New&quot; /&gt; &lt;/ItemTemplate&gt; &lt;PagerStyle BackColor=&quot;#999999&quot; ForeColor=&quot;Black&quot; HorizontalAlign=&quot;Center&quot; /&gt; &lt;RowStyle BackColor=&quot;#EEEEEE&quot; ForeColor=&quot;Black&quot; /&gt; &lt;/asp:FormView&gt; &lt;asp:SqlDataSource ID=&quot;edcalls&quot; runat=&quot;server&quot; ConflictDetection=&quot;CompareAllValues&quot; ConnectionString=&quot;&lt;%$ ConnectionStrings:abcd %&gt; &quot; DeleteCommand=&quot;DELETE FROM [event1] WHERE [id] = @original_id AND (([event name] = @original_event_name) OR ([event name] IS NULL AND @original_event_name IS NULL))&quot; InsertCommand=&quot;INSERT INTO [event1] ([event name]) VALUES (@event_name)&quot; OldValuesParameterFormatString=&quot;original_{0}&quot; ProviderName=&quot;System.Data.SqlClient&quot; SelectCommand=&quot;SELECT [id], [event name] AS event_name FROM [event1]&quot; UpdateCommand=&quot;UPDATE [event1] SET [event name] = @event_name WHERE [id] = @original_id AND (([event name] = @original_event_name) OR ([event name] IS NULL AND @original_event_name IS NULL))&quot;&gt; &lt;DeleteParameters&gt; &lt;asp:Parameter Name=&quot;original_id&quot; Type=&quot;Int32&quot; /&gt; &lt;asp:Parameter Name=&quot;original_event_name&quot; Type=&quot;String&quot; /&gt; &lt;/DeleteParameters&gt; &lt;InsertParameters&gt; &lt;asp:Parameter Name=&quot;event_name&quot; Type=&quot;String&quot; /&gt; &lt;/InsertParameters&gt; &lt;UpdateParameters&gt; &lt;asp:Parameter Name=&quot;event_name&quot; Type=&quot;String&quot; /&gt; &lt;asp:Parameter Name=&quot;original_id&quot; Type=&quot;Int32&quot; /&gt; &lt;asp:Parameter Name=&quot;original_event_name&quot; Type=&quot;String&quot; /&gt; &lt;/UpdateParameters&gt; &lt;/asp:SqlDataSource&gt;</pre> 2012-02-19T03:21:22-05:004839305http://forums.asp.net/p/1771119/4839305.aspx/1?Re+How+to+Run+Form+View+in+Web+serverRe: How to Run Form View in Web-server <p>Hello</p> <p>I have host-asp web-server. I wanto use form view for insert ,delete and edit. When I use My computer Connection string code is working but when I use server connection string it does not give me any error or does not show form view so please help me</p> 2012-02-19T03:24:32-05:004841980http://forums.asp.net/p/1771119/4841980.aspx/1?Re+How+to+Run+Form+View+in+Web+serverRe: How to Run Form View in Web-server <p></p> <blockquote><span class="icon-blockquote"></span> <h4>Pankil</h4> but when I use server connection string it does not give me any error or does not show form view so please help me</blockquote> <p></p> <p>Please try to connect to your database on your remote server file first by opening VSin the &quot;View&quot; menu plz open &quot;Solution Explorer&quot; and then create a connectionif that OKplz copy the conn string directly from the right-down property panel and paste into your own web.configthat'd be OK with you</p> <p>Reguards</p> 2012-02-21T00:44:21-05:00