Hi , I need some sample code that populates the checkBoxlist(C# Windows Application) based on the table values present is a SQL server database table.? Someone help in this regard.. Thanks in Advance,

Balaguru

Dear Christian Graus, Thx for ur reply..The thing is..the .csv/excel file resides only in the client machine.The user has to select the .csv/excel file from his machine and then click the load button in order to get it in a datagrid and finally post it to the database server. Regards,

Balaguru

Hi Friends... I am importing data from excel file to a datagrid.I use the following code to do that.But i get "Unspecified error" when i open the oledb connection.Wat could be the problem.Someone help in this regard...The code is given below... Private Sub btnClick_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClick.Click Try Dim filepath As String = System.IO.Path.GetFullPath(Me.FindFile.PostedFile.FileName) GrdExcel.DataSource = GetExcelData(filepath) GrdExcel.DataBind() Catch ex As Exception Response.Write(ex.Message) End Try End Sub Private Function GetExcelData(ByVal strpath As String) As DataSet Try Dim ExcelConnection As String = "" ExcelConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & strpath & ";" & "Extended Properties=""Excel 8.0;HDR=Yes""" Dim strExcelConn As String = ExcelConnection Dim dbConn As New Data.OleDb.OleDbConnection(strExcelConn) Dim strSQL As String Dim delimeter As Char() = {"\"} Dim splitter As String() = strpath.Split(delimeter) Dim file As String = splitter(splitter.Length - 1) strSQL = "SELECT * FROM [" & file & "$]" dbConn.Open() Dim cmd As New Data.OleDb.OleDbCommand(strSQL, dbConn) Dim dsExcel As New DataSet Dim daExcel As New Data.OleDb.OleDbDataAdapter(cmd) daExcel.Fill(dsExcel) dbConn.Close() Return dsExcel Catch ex As Exception Response.Write(ex.Message) End Try End Function

Balaguru

The following is third iframe in which i call a .aspx page.The code is as follows.. In login page Session value stored : Session("USERID") = gstrUserId In Game Page (3rd Iframe page) session value retrieved : lstrid = CType(Session("USERID"), String) (or) lstrid =Session("USERID") But i am getting "nothing" in lstrid , when i execute this with the help of breakpoint Wat could be the problem.? Thanks & Regards

Balaguru

Hi Friends.. I am having a login page (.aspx) which is a pop up page..Now i maintain a session in this login page to hold the username in the session..Now i need to retrieve this session in another page which is having 3 iframes..I need the session variable in the 3rd iframe..But when i try to retrieve i am getting "nothing" in the session..Wat might be the problem..? i am developing in .Net 2005 using atlas framework. Regards,

Balaguru

Ok then..Wats the solution to bring that checkbox into that datagrid..? Regards,

Balaguru

Dear Darkelv.. I am just displaying a checkbox in that datagrid's first column..I am not going to affect that table by any means with that checkbox..Ideally the checkbox itself is not shown..Then how could i think of making some changes in that table by means of that checkbox..? Reply in this regard... Thanks & Regards,

Balaguru

No.. I dont have any boolean column inside it..Moreover in the below code the table name has to be given in this tablestyle.MappingName.But since i have got the dataset being filled by a stored procedure..i couldn't do that..So what i should i specify in this tablestyle.MappingName..At present i have just given the dataset name in it i.e ldst which is not working.. tableStyle.MappingName = "ldst" Moreover if i use datagrid1.datasource= ldst.tables(0)..I get the values but without the checkbox column which is of no need.. Kindly reply...

Balaguru

Hi friends.. I need to bind a checkbox to the first column of my datagrid..I use the following code to do so...I bind the datagrid through a dataset named "ldst" .The code is below ldst = lobjclass1.TIC_GET_tTic_MM_ServiceType(0) now i am getting the dataset with values in it..After this i am using the following code to bind checkbox within the datagrid(datagrid1).. Dim tableStyle As New DataGridTableStyle tableStyle.MappingName = "ldst" Dim discontinuedCol As New DataGridBoolColumn discontinuedCol.MappingName = "Discontinued" discontinuedCol.HeaderText = "" discontinuedCol.Width = 30 'turn off tristate discontinuedCol.AllowNull = False tableStyle.GridColumnStyles.Add(discontinuedCol) 'Step 2: AgentID Dim column As New DataGridTextBoxColumn column.MappingName = "AgentID" column.HeaderText = "AgentID" column.Width = 30 tableStyle.GridColumnStyles.Add(column) 'Step 2: Bank Name column = New DataGridTextBoxColumn column.MappingName = "Bank Name" column.HeaderText = "Bank Name" column.Width = 140 tableStyle.GridColumnStyles.Add(column) 'Step 2: Branch Name column = New DataGridTextBoxColumn column.MappingName = "Branch Name" column.HeaderText = "Branch Name" tableStyle.GridColumnStyles.Add(column) 'Step 2: City column = New DataGridTextBoxColumn column.MappingName = "City" column.HeaderText = "City" tableStyle.GridColumnStyles.Add(column) 'Step 2: Cheque / DD Date column = New DataGridTextBoxColumn column.MappingName = "Cheque / DD Date" column.HeaderText = "Cheque / DD Date" tableStyle.GridColumnStyles.Add(column) 'Step 2: Cheque / DD No column = New DataGridTextBoxColumn column.MappingName = "Cheque / DD No" column.HeaderText = "Cheque / DD No" tableStyle.GridColumnStyles.Add(column) 'Step 2: Pay Type column = New DataGridTextBoxColumn column.MappingName = "Pay Type" column.HeaderText = "Pay Type" tableStyle.GridColumnStyles.Add(column) 'Step 3: Add the tablestyle to th

Hi Friends, I am using Atlas update panel in which i have my server controls such as text boxes and check boxes. I also have a button inside that update panel.when i click the button all the values are insertecd into the database table.But the thing is i am failing to get the return message in my front end label after the insertion is done..i.e i need to display in the label as "Successfully inserted".I have also written code for it.But it is not working..What might be the problem.Someone help in this regard.. Thanks & Regards,

Balaguru

Dear Bright.. How to write the HTML to a literal control and clear it..? Can u just give me some sample code to do that..? Thanks & Regards,

Balaguru

Hi friends.. I manually code to get tables holding values returned from database in an .aspx page.Now i need to clear those tables when i click the clear button which i have in my page..how to to it..someone help in this regard.. Regards,

Balaguru

Dear .Netman.. Nothing is there in ur reply..Can u resend ur reply... Regards,

Balaguru

Hi all.. I am having a aspx page which has a number of tables having values retrieved from dataset..I have a button in the page..When i click the button only the first two tables alone should be printed..That is i have 10 tables in that page then i need to print them two tables per page(print out page)..so that i will get 5 printout pages each having two tables in it..How to do that.Someone help in this regard.. Thx..

Balaguru

Hi friends.. I am developing a Web application in ASP.net..I need to get the harddisk serial number of the users machine who are visiting my application(my web Page)..How to do that..? Someone help me with relevant code as early as possible.. Thanks In Advance..

Balaguru

Dear Deepak.. How to Do that..Can u help me with the code.. Regards,

Balaguru

Dear Friends.. I am having an .aspx application.I need to restrict the CTRL + N key inorder to prevent the opening of my web page a new window..Some one help me with the code.. Thanks & Regards,

Balaguru

Dear Graus, I am just binding values to the dropdownlist from the database using the following code.Here ldset is the dataset ldset = gobjClass.CW_GETBETOPT() Dim lBetViewFilter As New DataView lDataRow = lDataViewFilter.Item(0).Row lBetViewFilter = FindValueInBetViewReturn(ldset, "GAMEID='" &lDataRow("GameID") &"'") Me.DropDownList1.DataSource = lBetViewFilter Me.DropDownList1.DataTextField = "bettypedesc" Me.DropDownList1.DataValueField = "BetTypeId" Me.DropDownList1.DataBind() Me.DropDownList1.SelectedIndex = 0 The problem is exactly what u said that is if i select item four and it posts back, item three is shown ..Kindly help in this regard.. Thanks in Advance..

Balaguru

Hi Friends.. I am having a .aspx page in which i have dropdown list box.I am binding values to the dropdownlist from the database..There are five items in the dropdown list box..When i run my .aspx page and select items it is not displayed properly.i.e for example if i select the fourth item the third item is selected..But all the other items which i select are displayed correctly..Only at the time of selecting the fourth item,the third item is shown.What could be the problem ..? Someone help in this regard as early as possible. Regards,

Balaguru

My dear Friend Friend.. Even if i might have wrongly posted,Just hold on ur words.. If u knew the answer post it or else shut and sit.. Regards,

Balaguru