|
I have drop just one WebPartManager Control on page, and i am getting following error message, eventhough i did not write any code.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Any idea please.
Know Yourself Then Grow Yourself.
|
|
|
|
|
You need a database back end for the personalization feature. If you do not need it you can add
personalization-enabled=false to your WebPartManager.
Hope it helped you.
|
|
|
|
|
Thanks Dear its working now.
Know Yourself Then Grow Yourself.
|
|
|
|
|
Hello eveyone,
I wonder if I can make a webservice work via a desktop application in which this webservice manipulates a web application (for example change a label) ?
Lets me explain in detail. I want to click a button on my destop application (which is currently viewing a web application) and this will make a webservice start to work. This webservice -then- will change a label on the web applications.
Thanks for your helps and best regards.
.:: Something is Wrong ::.
|
|
|
|
|
We can call a web service from a windows application. It is like a normal call to the web service.
Ram
|
|
|
|
|
i have bind the gridview through the data set
the dataset contans the boolen values so automatical it taks the Checkbox control
now i wnat to retryiving the data from gridviw
if checkbox is checked then i need check box value
here i give the my coding
here on page load
i get the data and
bind the grid view
protected void Page_Load(object sender, EventArgs e)
{
string connString = WebConfigurationManager.ConnectionStrings ["ServerConnectionString1"].ConnectionString;
SqlDataAdapter conadapuser = new SqlDataAdapter("SSTABEG", connString);
DataSet userdateset = new DataSet();
conadapuser.Fill(userdateset);
int rescount = userdateset.Tables[0].Rows.Count;
int colcount = userdateset.Tables[0].Columns.Count;
//trueval = bool.Parse(bool.TrueString);
DataTable dt = new DataTable();
for (int i = 0; i < userdateset.Tables[0].Columns.Count; i++)
{
DataColumn dc = new DataColumn();
if (i > 0)
{
dc.Caption = userdateset.Tables[0].Columns[i].Caption;
dc.DataType = System.Type.GetType("System.Boolean");
dc.ColumnName = userdateset.Tables[0].Columns[i].ColumnName;
}
else
{
dc.Caption = userdateset.Tables[0].Columns[i].Caption;
dc.DataType = userdateset.Tables[0].Columns[i].DataType;
dc.ColumnName = userdateset.Tables[0].Columns[i].ColumnName;
}
dt.Columns.Add(dc);
}
for (int row = 0; row < userdateset.Tables[0].Rows.Count;row++ )
{
DataRow drow=dt.NewRow();
for (int col = 0; col < userdateset.Tables[0].Columns.Count; col++)
{
if (col > 0)
{
if (userdateset.Tables[0].Rows[row][col].ToString() != "1")
{
drow[col] = false;
}
else
{
drow[col] = true;
}
}
else
{
drow[col] = userdateset.Tables[0].Rows[row].ItemArray[col].ToString();
}
}
dt.Rows.Add(drow);
}
GridView1.DataSource = dt; //userdateset;
GridView1.DataBind();
}
HERE I ENABLE THE CHECK BOX CONTROL
protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
for (int i = 1; i < e.Row.Cells.Count;i++)
{
if (e.Row.Cells[i].Controls[0].GetType().FullName == "System.Web.UI.WebControls.CheckBox")
((CheckBox)e.Row.Cells[i].Controls[0]).Enabled = true;
}
}
}
IF I CLICK THE BUTTON
I WANT SAVE THE ALL DATA OF GRID
HOW CAN I RETIVE TEH DATA FROM THE GRIIEDVIEW CONTROL
protected void Button1_Click1(object sender, EventArgs e)
{
IN THE EVENT I NEED TO GET THE ALL DATA FROM GRIED VIEW(GRIED VIEW CONTAINS THE ALL CHECKBOX FIELDS
}
mohamad rafi
|
|
|
|
|
Here I had a Dropdnlist and i need to extract the datavaluefield from the list and i have to insert in some other table.My code is...
Dim dt As SqlCommand
dt = New SqlCommand("Select CustomerId,CustName from Customer", dbconn)
sedr2 = dt.ExecuteReader()
ctList.DataSource = sedr2
ctList.DataTextField = "CustName"
ctList.DataValueField = "CustomerId"
ctList.DataBind()
cmdins = "Insert into Dept(CustomerId,Deptname)values(" &dtlist.DataValueField& ",'"& TxtBox1.text&"')
This is not giving any eror,but no CustomerId value is inserting into the Table,where i have to close the datareader,and how to retrive the customerid value for insertion.Help me.Thanks in advance.
kissy
|
|
|
|
|
You can access the value of selected item like this:
DropDownList1.SelectedItem.Value.ToString()
Best Regards,
Apurva Kaushal
|
|
|
|
|
But it is not taking the value.It is taking by defult the first Listitem value,not the selected one.what is the wrong?
Dim dtsl As SqlCommand = New SqlCommand("Select CustomerId from Customer where CustName='" & DtList.SelectedItem.Value.ToString() & "'", dbconn)
Dim custid As Integer = dtsl.ExecuteScalar()
And i am trying to insert this custid in the insert command.whats the wrong,I tried the same before,but not working.It is taknig by defult first listitem value as 1.
kissy
|
|
|
|
|
Check the code where you are binding the dropdownlist, it should be under if(!page.IspostBack) condition.
Best Regards,
Apurva Kaushal
|
|
|
|
|
It is like that only.But still the same problem is occuring.Is there any
Dim ctid As SqlCommand = New SqlCommand("Select CustomerId from Customer where CustName='" & ctList.SelectedItem.Text & "'", dbconn)
Dim custid As Integer = ctsl.ExecuteScalar()
This is also not working.It is taking by default value.Wats the wrong.It is simple but not working.
Am i need to change anywhere??
kissy
|
|
|
|
|
Actually what I have understood is you are binding the dropdownlist control in page load event, am I right? And then in some other event you are trying to catch the selected value of the dropdownlist control. is it so?
You just check the code for is post back because what could be a reason is that you dropdownlist control would be getting bind again prior to get the selected value. 
Best Regards,
Apurva Kaushal
|
|
|
|
|
ya ur gussing is correct,I have given the code as Aldobe given in the pageload event.I am tring to insert values in the other event.All are correct.
I am closeing the datareader in pageload (IF !page is postback).
How to get tthe exact value.Why it is not taking selectedItems's vlaue.
kissy
|
|
|
|
|
Dim dt As SqlCommand<br />
dt = New SqlCommand("Select CustomerId,CustName from Customer", dbconn)<br />
sedr2 = dt.ExecuteReader()<br />
<br />
If(Not Page.IsPostBack) Then<br />
ctList.DataSource = sedr2<br />
ctList.DataTextField = "CustName"<br />
ctList.DataValueField = "CustomerId"<br />
ctList.DataBind()<br />
End If
(sorry if i have any syntax error on vb.net code cuz i'm C# prog.)
|
|
|
|
|
I have given the same code in pageload.
but how to retrieve in my insert query to insert the DataValueField.
THis is my doubt.
kissy
|
|
|
|
|
|
It is giving an error as you should enter a constants,varibles or expressions.It should not take 'Name' ('Name' is customerName)in this context.
So how to use this expression.
kissy
|
|
|
|
|
Dude can u post more ur code ???
|
|
|
|
|
U can see my first Message.That is in my Button event.
And ur first code is in my pageload.
Got my point,Simple but nnot working.
Thanks.
kissy
|
|
|
|
|
Here comes the problem the code what you have given in the first message then that means is you are again binding that drop down list in that event and after that you are trying to get the selected value. How will it happen.  Remove the binding code from there.
Best Regards,
Apurva Kaushal
|
|
|
|
|
This is my code when pageload
Dim dt As SqlCommand
dt = New SqlCommand("Select CustomerId,CustName from Customer", dbconn)
sedr2 = dt.ExecuteReader()
ctList.DataSource = sedr2
ctList.DataTextField = "CustName"
ctList.DataValueField = "CustomerId"
ctList.DataBind()
In Button event ,my code is
issert into Dept(custId,dname)values(" & ctlist.selectedValue&",'"&txtbox1.text&"').
But the value is not coming into the selectedvalue.I have given the code correctly.try to Understand and solve it.whhat exactly i have to give for retrieving the respcted Datavaluefield into my 'cutsid'.
kissy
|
|
|
|
|
Dim dt As SqlCommand<br />
dt = New SqlCommand("Select CustomerId,CustName from Customer", dbconn)<br />
sedr2 = dt.ExecuteReader()<br />
If Not Page.IsPostBack Then<br />
ctList.DataSource = sedr2<br />
ctList.DataTextField = "CustName"<br />
ctList.DataValueField = "CustomerId"<br />
ctList.DataBind()<br />
End If<br />
<br />
insert into Dept(custId,dname)values('" & ctlist.selectedValue&"','"&txtbox1.text&"')
this code doesn't return selected value of ctlist??? (amazing)
or do u bind ctlist in any other event(s)????
|
|
|
|
|
No this is only mycode where i am using Dtlist.All other is not related with this.i am still trying,ok if u get any answer send me please.thank you.
binding is at pageload,and only insertion is at button clik event.
Give me a solution.
kissy
|
|
|
|
|
my problem was solved,thanks for ur cooperation.
kissy
|
|
|
|
|
I'm glad...
Where were problem???
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
