You searched for the word(s): userid:823715

More Search Options

RSS Available

• Re: SQLDataSource Problem in VSWD 2008

  it is c# code. i wrote it in the button_click event.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by amritbera on 3/26/2009

• Re: SQLDataSource Problem in VSWD 2008

  Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif";

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by amritbera on 3/26/2009

• Re: SQLDataSource Problem in VSWD 2008

  i searched a lot. but everywhere it is stated that not to use the fixed length size data-types in the database. like nvarchar. but i am getting 50 by default. i also tried to use the text datatype, as it dosent have any fixed size.. but this also dosent solve the problem. just before the insert paramater, i gave label1.text = apprval. even in the label it is showing properly, completely trimmed.. but after inserting, when i am checking the back end database table, there it is full of extra spaces

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by amritbera on 3/18/2009

• Re: SQLDataSource Problem in VSWD 2008

  i think u didnt get the problem. plz go through the main post. i search a lot about this problem, everywhere it is asked to use the nvarchar insted of the nchar.. so i did. but it is of no use. thank you

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by amritbera on 3/16/2009

• Re: SQLDataSource Problem in VSWD 2008

  ya i used that function. but its of no use. and i gave that nvarchar(500) datatype but its not solving the problem.. i also tried to remove the "(500)" but, by default it is takeing 50. how to solve this ?? thank you

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by amritbera on 3/15/2009

• Re: SQLDataSource Problem in VSWD 2008

  guys please help.... i'm stuck in my project only for this.... thank you

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by amritbera on 3/13/2009

• Re: SQLDataSource Problem in VSWD 2008

  guys.. this solution is not working. i tried both, the trim function and the nvarchar datatype.. but the same this is happening. what to do?? the variable is correctly stored. but as soon as the insert function is called, "spaces" are added in the value. i dont know why.. please help;; thank you

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by amritbera on 3/13/2009

• Re: search problem

  guys plz give me the code... thank you all in advance

  Posted to Getting Started (Forum) by amritbera on 3/12/2009

• Re: SQLDataSource Problem in VSWD 2008

  thanks a lot for your reply.. i ll try ur instructions and surely report you. thank you agaIN

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by amritbera on 3/12/2009

• SQLDataSource Problem in VSWD 2008

  I have a table with 3 columns, Program (nchar 500) Approval (nchar 200) Details (nchar 200) Here, I am filling the data in the “details” column by, SqlDataSource1.InsertParameters[ "further_details" ].DefaultValue = TextBox1.Text; And there are two lists: < asp : ListBox ID ="ListBox1" runat ="server SelectionMode ="Multiple" DataSourceID ="SqlDataSource2" DataTextField ="approval" DataValueField ="approval" ></ asp : ListBox

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by amritbera on 3/12/2009