|
|
This is the Select query that i am using while developing ASP.Net app using VB.Net My EventDate is in General Date format.But gDate is in Short Date format.So query not produsing any out put.
Dim gDate As DateTime = txtDate.Text.Trim()
SelectQueryText = "SELECT Distinct UserID,EventDate FROM History WHERE Dept='" + lstDept.SelectedValue.Trim() + "'AND EventDate=" + gDate + ""
What is the currect query to get the OutPut?
Praveen.K
System Engineer
Graviton Technologies Pvt.Ltd
|
|
|
|
|
change EventDate as shortdate then compare
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
Sir,
Actually i dont ve the permission to change the format of EventDate in DB...Then what i should do?Is there any provision to change the format of record at rub time?
Praveen.K
System Engineer
Graviton Technologies Pvt.Ltd
|
|
|
|
|
Hi All,
I have Datatable, which is created at runtime and Bind with GridView.What I want is to make two columns of that datatable visible false.
Please tell me how do I go about the same.
Thanks in advance...
|
|
|
|
|
I think you want to make columns of the gridview to be invisible not os the datatable, right?
Best Regards,
Apurva Kaushal
|
|
|
|
|
Actually you are right but I tried that on RowDataBound event but it didnt work.
Any help??
|
|
|
|
|
I think when you are binding the gridview at that time you can make them visible = false (Can't you do that in design time). Are you creating the gridview dynamically?
Best Regards,
Apurva Kaushal
|
|
|
|
|
Actually I am binding Gridview with ViewState DataTable on Add button click.Following is the code:
strSql = "SELECT ColumnName, ColumnDataType FROM sysDataTypeTable WHERE ID =" & cmbGFormName.Items(cmbGFormName.SelectedIndex).Value
objDT = objDB.ExecuteDatatable(strSql)
If Not ViewState("WhereClause") Is Nothing Then
'DataTable is available in ViewState
GridViewQuery.AutoGenerateColumns = True
If htxtEditOrAdd.Value = "Edit" Then
index = htxtSrNo.Value
If cmbGFormName.SelectedIndex <> 0 And cmbOperator.SelectedIndex <> 0 Then
CType(ViewState("WhereClause"), Data.DataTable).Rows(index).Item("FieldName") = cmbGFormName.Items(cmbGFormName.SelectedIndex).Text
CType(ViewState("WhereClause"), Data.DataTable).Rows(index).Item("Operator") = cmbOperator.Items(cmbOperator.SelectedIndex).Text
CType(ViewState("WhereClause"), Data.DataTable).Rows(index).Item("Value") = txtValue.Value
If chkAndOR.Checked Then
CType(ViewState("WhereClause"), Data.DataTable).Rows(index).Item("ANDOR") = "OR"
Else
CType(ViewState("WhereClause"), Data.DataTable).Rows(index).Item("ANDOR") = "AND"
End If
GridViewQuery.DataSource = ViewState("WhereClause")
GridViewQuery.DataBind()
htxtEditOrAdd.Value = ""
htxtSrNo.Value = ""
End If
Else
If cmbGFormName.SelectedIndex <> 0 And cmbOperator.SelectedIndex <> 0 Then
Dim objDR As DataRow
objVDT = ViewState("WhereClause")
objDR = objVDT.NewRow()
objDR("FieldName") = cmbGFormName.Items(cmbGFormName.SelectedIndex).Text
objDR("Operator") = cmbOperator.Items(cmbOperator.SelectedIndex).Text
objDR("Value") = txtValue.Value
If chkAndOR.Checked Then
objDR("ANDOR") = "OR"
Else
objDR("ANDOR") = "AND"
End If
objDR("ColumnDataType") = objDT.Rows(0).Item(1).ToString
objDR("ColumnName") = objDT.Rows(0).Item(0).ToString
objVDT = ViewState("WhereClause")
objVDT.Rows.Add(objDR)
GridViewQuery.DataSource = ViewState("WhereClause")
GridViewQuery.DataBind()
End If
End If
Else
objVDT = New DataTable("WhereClause")
objDC = New DataColumn
'Sr No Column
objDC = objVDT.Columns.Add("SrNo", System.Type.GetType("System.String"))
objDC.Caption = "Sr No"
objDC.AutoIncrement() = True
'Field Name Column
objDC = objVDT.Columns.Add("FieldName", System.Type.GetType("System.String"))
objDC.Caption = "Field Name"
'Operator Column
objDC = objVDT.Columns.Add("Operator", System.Type.GetType("System.String"))
objDC.Caption = "Operator"
'Value Column
objDC = objVDT.Columns.Add("Value", System.Type.GetType("System.String"))
objDC.Caption = "Value"
'And/Or Column
objDC = objVDT.Columns.Add("ANDOR", System.Type.GetType("System.String"))
objDC.Caption = "AND/OR"
objVDT.Columns.Add(New DataColumn("ColumnDataType"))
objVDT.Columns.Add(New DataColumn("ColumnName"))
ViewState("WhereClause") = objVDT
Dim objDR As DataRow
objDR = objVDT.NewRow()
If txtValue.Value <> "" Then
objDR("SrNo") = 1
objDR("FieldName") = cmbGFormName.Items(cmbGFormName.SelectedIndex).Text
objDR("Operator") = cmbOperator.Items(cmbOperator.SelectedIndex).Text
objDR("Value") = txtValue.Value
If chkAndOR.Checked Then
objDR("ANDOR") = "OR"
Else
objDR("ANDOR") = "AND"
End If
<b>'Make this 2 columns visible false.</b>
objDR("ColumnDataType") = objDT.Rows(0).Item(1).ToString
objDR("ColumnName") = objDT.Rows(0).Item(0).ToString
objVDT.Rows.Add(objDR)
GridViewQuery.DataSource = objVDT
GridViewQuery.DataBind()
End If
End If
Please tell me how do I make it visible false??
|
|
|
|
|
You use to scare with these looong sode snippets.. 
I think just after you bind the gridview you can simply hide the column by using
GridView1.Columns[1].Visible = false;
or also just when you binding the gridview one event gets fired just as onitemdatabound in datagrid there also it can be done...
Best Regards,
Apurva Kaushal
|
|
|
|
|
I have tried this but its not working.
GridViewQuery.Rows(SrNo).Cells(2).Text = objDT.Rows(0).Item(1).ToString
GridViewQuery.Columns(2).Visible = False
GridViewQuery.Rows(SrNo).Cells(3).Text = objDT.Rows(0).Item(0).ToString
GridViewQuery.Columns(3).Visible = False
Its giving runtime error that index was out of range.
|
|
|
|
|
You first check whether that many columns are there or not. If you are having the columns then certainly you can make them visible false with that code.
Best Regards,
Apurva Kaushal
|
|
|
|
|
What I am doing is taking 2 Bound Columns in gridview(which I have to hide)and then binding it viewstate datatable with gridview. but it gives runtime error.
|
|
|
|
|
You check the columns count and then try to hide. Check whether you are having that columns or not after you bind.
Best Regards,
Apurva Kaushal
|
|
|
|
|
I got some code on google but it showing some error:
Dim mt As DataTable
' Define datatable
Dim col As DataColumn
' Define columns
newGrid.DataSource = mt
' define datasource for datagrid
For Each col In mt.Columns
' go through all the columns
Dim dg As New BoundColumn()
' create a new bound column
dg.DataField = col.ColumnName
' define the column name in datagrid
newGrid.Columns.Add(dg)
' add the column to datagrid
If col.ColumnName = "ID" Then
' if the field is a unique id
newGrid.Columns(col.Ordinal).Visible = False '
set visible = false
End If
Next
newGrid.DataBind()
it giving error on newGrid.Columns.Add(dg) line.It says cannot control to System.Web.UI.WebControls.BoundColumn to System.Web.UI.WebControls.DataControlField.
Trying to analysis the code.
If u can help me for the same.
|
|
|
|
|
Thanks Apurva its working now.
|
|
|
|
|
|
i have a gridview with only one column and several rows.in each row i have added buttons through templte field.i have 2 show somw other data depending upon which button is clicking.hw 2 find which button is clickng???i am doing it in c# in .net 2.0...
|
|
|
|
|
I think you can assign commandname property of the button and then can identify on the basis command them in the event.
Best Regards,
Apurva Kaushal
|
|
|
|
|
you have good examples on this in 4guysfromrolla!!!
Gautham
|
|
|
|
|
Hello & smiles,
Can someone kindly guide as to what is going wrong in my Sub below? I am getting the error as :
System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ProfitLossData_CBValues". The conflict occurred in database "ProfitLossRegister", table "dbo.CBValues", column 'cbno'. The statement has been terminated.
------------------------------------------------------------------------------------------
Protected Sub btnsave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnsave.Click
Dim connectionsave = New SqlConnection(ConnectionString)
Dim Commandsave As SqlCommand
Dim forecastbox As String
Dim commentbox As String
Dim catvalue As String
Dim CBVal As String
Dim PLGridRow As GridViewRow
Commandsave = New SqlCommand
Commandsave.Connection = connectionsave
Try
connectionsave.open()
'iterate through all the gridrows
For Each PLGridRow In PLForecastGrid.Rows
forecastbox = CType(PLGridRow.FindControl("txtforecastbdgt"), TextBox).Text
commentbox = CType(PLGridRow.FindControl("txtcomments"), TextBox).Text
catvalue = PLGridRow.Cells(0).Text
lbltest1.Text = catvalue
CBVal = PLGridRow.Cells(1).Text
lbltest2.Text = CBVal
Commandsave.CommandText = " Insert into profitlossdata"
Commandsave.CommandText += " (forecastbdgt,comments,branchno,yearno,"
Commandsave.CommandText += " bpno,catno,cbno)"
Commandsave.CommandText += " Values ('" & forecastbox & "', "
Commandsave.CommandText += "'" & commentbox & "', "
Commandsave.CommandText += "'" & lblbrvalue.Text & "', "
Commandsave.CommandText += "'" & lblyrvalue.Text & "', "
Commandsave.CommandText += "'" & lblbpvalue.Text & "', "
Commandsave.CommandText += "'" & lbltest1.Text & "', "
Commandsave.CommandText += "'" & lbltest2.Text & "')"
Commandsave.ExecuteNonQuery()
Next
lblmessage.Text = " Records Created!"
Catch ex As Exception
lblmessage.Text = ex.ToString
Finally
connectionsave.close()
End Try
End Sub
------------------------------------------------------------------------------------------------
'cbno' is a foreign key on my table. The values of cbno are displayed on the gridview with a Join when the grid loads. I have to save these values in my master table so I am reading the the value of cbno for each row in a label(with findcontrol) and then inserting this label value into the mastertable but in the cbno column which is a foreign key.
I hope I haven't confused you all. Please help!
Thank you.
Aartee.
...HE is watching Us All!
|
|
|
|
|
Probably the problem has nothing to do with the gridview. Just check the values you are inserting as foreign key in the table, whether it exests in the master table or not.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi Apurva,
Thankyou for your prompt reply.
In my gridview the values are coming from CBValues table & CbNo is ID of that table and foreign key of my master (profitlossdata) table. I am populating my gridview with CBNo and some other template columns. Then I am trying to insert these values into my master table on a button click event as in the sub in my previous post, so these values will exist in master table only if the Insert statement works, and that is my problem, the insert stt is failing... or am I confused?...well it's 3:30pm in Adelaide  I guess my brain is off for a nap.
Can you kindly explain it a bit more in detail?
Thanks a million.
Aartee.
...HE is watching Us All!
|
|
|
|
|
The only problem what I can guess is some ID(which you are inserting in the second table as a foreign key) does not belong to the first table(i.e. ID not there in the first table). Can you check them again?
Best Regards,
Apurva Kaushal
|
|
|
|
|
The DRP System use asp.net tech and Sql server 2000
3 level tech architcture.
www.drpsky.com
Good friend
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
