problem with the text box
-
There is a big problem for me as I have to handle a project made by an other person and I m not aware of this code.I have two tables in SQL Server 2005 named AudioFileDetails having fields---- FileId int 4, FileName varchar 1000, Subject varchar 500, DistrictId smallint 2 and other table is DistrictDetails with the fields ------- DistrictId smallint 2, DistrictName varchar 100.I have a query form (ASP.NET) that have two fields named Subject and DistrictName, both dropdownlist box with the entries from the database .In this web form there is a button named Go to execute the query.The button is working ie records are displayed according to the value selected from the dropdownlist either from District or from the Subject or from the both.The result is shown in the grid which is given below the GO button.This grid have two fields named Subject and DistrictName and a button named Play ,on which the user can click and play the file that is displayed from the query.When the user click on the play button an another form is displayed that contains a windowsVedioMedia to play that audio file (as the files are audio files), two text boxes that displays two fields subject , DistrictName and a button Save to save the entries if user have edited.These fields contains the value of the subject and DistrictName of the file being played.But my problem is that as subject is directly taken from the AudioFileDetails table that is from the database but the DistrictName value is not coming in the District text box.The district field contains no value in the form ,but there is the entry in the database of that field. fields.Please tell me how can I get the value of District field in that table as in the database there is a field named DistrictId not DistrictName and also a coding to save the edited value also.Please give me in detail as I m not so aware of this language……..i m giving u the entire code used.......some error is there so please let me know..... _______________________________________________________ AudioSearch.aspx.cs Using System; Using System.Data; Using System.configuration; Using System.web; Using System.web.Security; Using System.web.UI; Using System.web.UI.Webcontrols; Using System.web.UI.Webcontrols.webparts; Using System.web.UI.HtmlControls; Using System.Data.Sqlclient; public partial class AudioSearch: System.web.UI .Page { protected void page_load(object sender,EventArgs e) { if(!page.IsPostBack) { try { DataSet ds1=New DataSet(); DataSet ds2=New DataSet(); AudioSear
-
There is a big problem for me as I have to handle a project made by an other person and I m not aware of this code.I have two tables in SQL Server 2005 named AudioFileDetails having fields---- FileId int 4, FileName varchar 1000, Subject varchar 500, DistrictId smallint 2 and other table is DistrictDetails with the fields ------- DistrictId smallint 2, DistrictName varchar 100.I have a query form (ASP.NET) that have two fields named Subject and DistrictName, both dropdownlist box with the entries from the database .In this web form there is a button named Go to execute the query.The button is working ie records are displayed according to the value selected from the dropdownlist either from District or from the Subject or from the both.The result is shown in the grid which is given below the GO button.This grid have two fields named Subject and DistrictName and a button named Play ,on which the user can click and play the file that is displayed from the query.When the user click on the play button an another form is displayed that contains a windowsVedioMedia to play that audio file (as the files are audio files), two text boxes that displays two fields subject , DistrictName and a button Save to save the entries if user have edited.These fields contains the value of the subject and DistrictName of the file being played.But my problem is that as subject is directly taken from the AudioFileDetails table that is from the database but the DistrictName value is not coming in the District text box.The district field contains no value in the form ,but there is the entry in the database of that field. fields.Please tell me how can I get the value of District field in that table as in the database there is a field named DistrictId not DistrictName and also a coding to save the edited value also.Please give me in detail as I m not so aware of this language……..i m giving u the entire code used.......some error is there so please let me know..... _______________________________________________________ AudioSearch.aspx.cs Using System; Using System.Data; Using System.configuration; Using System.web; Using System.web.Security; Using System.web.UI; Using System.web.UI.Webcontrols; Using System.web.UI.Webcontrols.webparts; Using System.web.UI.HtmlControls; Using System.Data.Sqlclient; public partial class AudioSearch: System.web.UI .Page { protected void page_load(object sender,EventArgs e) { if(!page.IsPostBack) { try { DataSet ds1=New DataSet(); DataSet ds2=New DataSet(); AudioSear