|
Hi,
Iam New to Webservices,Plz refer good material to learn webservices quickly
iam awaiting for reply
Thanks & Regards
Srilakshmi
|
|
|
|
|
To start you can have a look at this[^]
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi,
When i was creating the proxy at command prompt i got the error like "wsdl is not recognized as an internal or external command"
Why this error come,and also why we prefer proxy to expose webservice methods,cant we directly expose?.
Plz calrify my doubts, otherwise suggest good link
Advanced Thanks
Srilakshmi
|
|
|
|
|
I think you need to set the environment variable for that.
Best Regards,
Apurva Kaushal
|
|
|
|
|
hi,
i would like to have something like netmeeting in my asp.net application. can i integrate netmeeting with our asp.net application. is it possible?. will you let me know how?
thanks in advance
sebastian
|
|
|
|
|
|
You have to use MySql.Data.dll
Place it in C:/windows/System32 and refer it in your application.
|
|
|
|
|
|
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...
|
|
|
|