|
Hi all,
Can anyone help me out with this:
in my datagrid's ItemDataBound event, I want the method to do something like this:
private void onItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if (e.Item? or e.Item.Cells[0].Controls[0]??? == a CheckBox object)
// then do stuff
else
// do nothing
}
any ideas?
|
|
|
|
|
Hi,
I think there are two possibilities to do that:
1) if(e.Item.Cells[0].Controls[0] is System.Web.UI.WebControls.CheckBox) { // do something }
2) if(e.Item.Cells[0].Controls[0].GetType().Equals(typeof(System.Web.UI.WebControls.CheckBox))) { // do something }
I don't know if the first one is correct, I always use the second possibility. But be sure to test if there is a cell or control and that it is not null before you use the GetType() method (otherwise there will be a NullReferenceException).
Regards
Sebastian
|
|
|
|
|
I have something like this:
string a=string.Empty;
if(b!=a){}
from this i can check if b is a empty variable for the condition of the if loop.
there isn't any int.Empty, how can i do the same if i want to compare if a int variable in empty for a if loop?
|
|
|
|
|
An int when declared is initialised to 0 if i am not wrong, or just rubbish value. Either way, they can't be "empty".
<font=arial>Weiye Chen
Life is hard, yet we are made of flesh...
|
|
|
|
|
|
Vikram A Punathambekar wrote:
Not rubbish, only 0s in C#
Yeah, thanks for confirming that. 
<font=arial>Weiye Chen
Life is hard, yet we are made of flesh...
|
|
|
|
|
The property string.Empty is just a static string with the value "".
string a = string.Empty;
has the same effect as:
string a = "";
The only difference is that the second one creates a new string object, while the first one uses the empty string that already exists.
As there is no gain in having static instances of value types, there isn't any static zero constant. Just use the value zero:
int a = 0;
---
b { font-weight: normal; }
|
|
|
|
|
hi
i have some experience in c++ and vc++
i want to migrate to .net
would u tell me which language should i learn first for .net??
ive heard that c# is the mother of .Net .so i should learn c# first or go directly to visual c++.net??
and also i awnt to learn asp.net what should i do?
thx
|
|
|
|
|
The is no difinitive answer to that question.
I work with c# because my background experience is in Java, and the similarities made it easy to migrate from Java to c#. Also most of the readily available books on writing Windows apps. and asp.net web form's are orientated around c# and VB, although i'm sure it is easy to get hold of books orientated around c++.
The beauty of Visual Studio.net is that all the language's have more or less the same level of functionality.
Check out http://msdn.microsoft.com/vstudio/productinfo/topten/upgrade.aspx
|
|
|
|
|
t-seanm wrote:
I work with c# because my background experience is in Java,
Out of curiosity, what reasons did you have for trying .NET? Does .NET provide anything significant over what the Java frameworks do?
Kevin
|
|
|
|
|
Well to tell u the truth the only reason I took up .Net is I am currently an intern in Microsoft Ireland. But there are so many advantages...
The excellent help section that comes with Visual Studio and online, not to mention the code samples.
The Microsoft press release contains tonnes of book for helping developers do just about anything.
You have to pop-up menus that appear each time you use dot notation, telling you what methods are available to you.
I always wanted to learn to use ASP.NET and with talking to people here at MS Ireland, c# or VB are the languages of choice for ASP.NET applications. Since c# is similar to Java, I chose it over the other languages. I picked it up quite easily, and i've never been a fan of VB, the syntax annoys me for some reason.
|
|
|
|
|
Don't you get similar help and samples with Java?
Kevin
|
|
|
|
|
Hello
It all depends upon the kind of Background u come from, by that i mean which language you are well versed with. Since you have been using C++ and vc++ earlier it would make things easier for you if u go for VC++.net.
As for C# it's Language worth learning and easy to pick up too.
best of luck!!!
|
|
|
|
|
I have a class to which I can pass any SQL query and it can return “DataReader” object or “DataSet” etc. To achieve this I have different methods in that class.
What is the best way to use database connection in ASP.NET application? I would like to use connection pooling too. Database is SQL Server 2000. Should we use singleton class in this, if yes, how can we use?
I appreciate your help.
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
- ashish
|
|
|
|
|
Connection pooling in ASP.NET happens all by itself, you can just create connections as you need them, I believe.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Yes, while using SqlClient and in connection string saying "connection pooling=true" automatically create connection pool for the same connection string.
What if there are multiple threads needs connection at same time? The error I get is, all the connection in connection pool are in use, and connection timed out. So I thought that this should not be the best way to use ADO.NET in ASP.NET
- ashish
|
|
|
|
|
You can change how many connections are in the pool, I believe. Other than that, I'm not sure. We just create connections as we need them and don't have any troubles.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
You can also specify "Max Pool Size" and "Min Pool Size" to adjust your pool. But I think this is specific to SQL Server only.
Thanks.
modified 17-Jul-19 21:02pm.
|
|
|
|
|
Here's my code:
public void dgTickets_Update(Object sender, DataGridCommandEventArgs e){<br />
string tdate, tnum, tcID, tter, tsc, tcu, tloc, tinfo, tid;<br />
<br />
tdate=((TextBox)e.Item.Cells[1].Controls[0]).Text;<br />
tnum=((TextBox)e.Item.Cells[2].Controls[0]).Text;<br />
tcID=((TextBox)e.Item.Cells[3].Controls[0]).Text;<br />
tter=((TextBox)e.Item.Cells[4].Controls[0]).Text;<br />
tsc=((TextBox)e.Item.Cells[5].Controls[0]).Text;<br />
tcu=((TextBox)e.Item.Cells[6].Controls[0]).Text;<br />
tloc=((TextBox)e.Item.Cells[7].Controls[0]).Text;<br />
tinfo=((TextBox)e.Item.Cells[8].Controls[0]).Text;<br />
tid=((TextBox)e.Item.Cells[9].Controls[0]).Text;<br />
<br />
string sSqlCmd = "UPDATE MCI_Tickets SET t_date = ?, t_num = ?, t_circuitID = ?, t_ter = ?, t_sc = ?, t_cu = ?, t_loc = ?, t_info = ? WHERE t_id = ?";<br />
SqlConnection updCon = new SqlConnection(Conn);<br />
SqlCommand updCmd = new SqlCommand(sSqlCmd, updCon);<br />
<br />
updCmd.Parameters.Add(new SqlParameter("@t_date", SqlDbType.Char, 10));<br />
updCmd.Parameters["@t_date"].Value = tdate;<br />
updCmd.Parameters.Add(new SqlParameter("@t_num", SqlDbType.Char, 5));<br />
updCmd.Parameters["@t_num"].Value = tnum;<br />
updCmd.Parameters.Add(new SqlParameter("@t_circuitID", SqlDbType.Char, 15));<br />
updCmd.Parameters["@t_circuitID"].Value = tcID;<br />
updCmd.Parameters.Add(new SqlParameter("@t_ter", SqlDbType.Char, 5));<br />
updCmd.Parameters["@t_ter"].Value = tter;<br />
updCmd.Parameters.Add(new SqlParameter("@t_sc", SqlDbType.Char, 6));<br />
updCmd.Parameters["@t_sc"].Value = tsc;<br />
updCmd.Parameters.Add(new SqlParameter("@t_cu", SqlDbType.Char, 6));<br />
updCmd.Parameters["@t_cu"].Value = tcu;<br />
updCmd.Parameters.Add(new SqlParameter("@t_loc", SqlDbType.NVarChar, 50));<br />
updCmd.Parameters["@t_loc"].Value = tloc;<br />
updCmd.Parameters.Add(new SqlParameter("@t_info", SqlDbType.NVarChar, 50));<br />
updCmd.Parameters["@t_info"].Value = tinfo;<br />
updCmd.Parameters.Add(new SqlParameter("@t_id", SqlDbType.Int, 4));<br />
updCmd.Parameters["@t_id"].Value = tid;<br />
<br />
updCon.Open();<br />
updCmd.ExecuteNonQuery();<br />
updCon.Close();
I keep getting the error:
Incorrect syntax near '?'
all the values show correct when i run through the Locals in the debugger. Would it be a problem with the database?
TIA,
Scott
|
|
|
|
|
sonicsqwirl wrote:
string sSqlCmd = "UPDATE MCI_Tickets SET t_date = ?, t_num = ?, t_circuitID = ?, t_ter = ?, t_sc = ?, t_cu = ?, t_loc = ?, t_info = ? WHERE t_id = ?";
sonicsqwirl wrote:
Incorrect syntax near '?'
Obviously, the ? are still in the code. I've never seen this syntax anywhere, do you have a reference to indicate that it should work ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
yes we used it in school on an application that updates an Access database ex. Code:
string sSqlCmd = "UPDATE Parts SET Name = ?, Description = ?, Price = ? WHERE PartID = ?";<br />
<br />
updCmd.Parameters.Add(new OleDbParameter("@PartDescription", OleDbType.VarWChar, 100));<br />
updCmd.Parameters["@PartDescription"].Value = sPartDescription;<br />
updCmd.Parameters.Add(new OleDbParameter("@PartPrice", OleDbType.Currency));<br />
updCmd.Parameters["@PartPrice"].Value = sPrice;<br />
updCmd.Parameters.Add(new OleDbParameter("@PartID", OleDbType.Integer));<br />
updCmd.Parameters["@PartID"].Value = sPartID;<br />
<br />
updCon.Open();<br />
updCmd.ExecuteNonQuery();<br />
updCon.Close();
any ideas on how i can do this differently?
|
|
|
|
|
Well, the most obvious way would be to use a stringbuilder to build the SQL, or even the string.Format method. I would have expected to only add parameters when calling a stored procedure. If a stored proc is an option here, I'd go with that instead.
I've just checked, and MSDN says this:
The .NET Framework Data Provider for SQL Server does not support the question mark (?) placeholder for passing parameters to a Transact-SQL statement or a stored procedure called by a command of CommandType.Text. In this case, named parameters must be used. For example:
SELECT * FROM Customers WHERE CustomerID = @CustomerID
In other words, if you change the ? to the same paramater names as the names you're using to add paramaters, then this approach will work, and is probably the best way to go outside of using a stored procedure. The main problem with this approach is that it opens you to SQL Injection attacks.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Isn't that the syntax for using the ODBC adapter with named paramters?
|
|
|
|
|
Yes, so I learned. I've never used the ODBC adapter before. Beats me why it differs.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
After installing the Oracle ODT I find that now I can access all my Oracle 10 databases perfectly, but the older Oracle 8i systems are no longer available.
I understand this is a known problem, has anyone else encountered this and knows of a work around ?
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
