|
I want to transfer data present in Access database to sqlserver i have written this code but its not working cant understand y
Plz help
private void button1_Click(object sender, System.EventArgs e)
{
OdbcConnection myconn = new OdbcConnection("DSN=test");
SqlConnection conn = new SqlConnection("server=.;database=techpaymaster;uid=sa;password=;Pooling=false;Connect Timeout=55;");
OdbcCommand da = new OdbcCommand("select * from tinfo",myconn);
myconn.Open();
OdbcDataReader dr=da.ExecuteReader();
while(dr.Read())
{
string i =(string)dr["Name"];
int j =(int)dr["Age"];
conn.Open();
SqlCommand cmd = new SqlCommand("insert into sadd(Namee,Agee)values('" + i + "'," + j + ")",conn);
cmd.ExecuteNonQuery();
}
|
|
|
|
|
What error you are getting ?
|
|
|
|
|
This is the error i am getting
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
|
|
|
|
|
Cuckoo wrote: SqlException
SqlException can happen when your query is not well formed. Use parameterized queries or assign your query to a string and print it before you pass it to SQLCommand . This will help you to identify the problem.
|
|
|
|
|
Hi all,
I am using arraylist,it contains suppose 100 elements.Here i need to sum the first 15 elements and second 15 elements vice versa.
now second 15 elements should be first 15 + sencond 15 elements sum should come.
Can any body can help
thanks in advance,
eswar
|
|
|
|
|
Hi all,
Is there a way that I can set the Calender control to display only the month and year and not the days of the month?
Thanks in advance
No matter how long he who laughs last laughs, he who laughs first has a head start!
|
|
|
|
|
I am not sure, but have you tried inheriting calendar control and overriding Render() ?
|
|
|
|
|
Nope, guess I have some reading up to do
No matter how long he who laughs last laughs, he who laughs first has a head start!
|
|
|
|
|
I have read an article on inheriting calendar class and customizing it on 4guys from rolla website. But I don't have the URL in my hand right now
|
|
|
|
|
|
Print the sqlstatement variable and run that query in your SQL query browser and see what is happening.
|
|
|
|
|
Hi
I am using a GridView to add some rows at run time. I've used databound colums to delete the relevent row of the Grid.
When I delete the row at run time and after that I press F5 key to referesh the page it looks for the last called event for the delete button, but the button is now deleted, so it gives an error.
Kindly give me a solution.
Vijay
|
|
|
|
|
Hi,
After deleting just redirect the page to same page.
Bhanu
|
|
|
|
|
hi ! ALL
i have used datagrid and there is template field of checkbox in client side. i am using async postback. so how can check all checkbox of grid in client side. pls help me. When validation are true then page should be postback.
|
|
|
|
|
How to pass session value in javascript
help me with code
thanx in advance
suman.c
|
|
|
|
|
<script language="javascript">
function sample()
{
var a = <%= Session["value"].ToString() %>;
}
</script>
|
|
|
|
|
click on link and one pop up window should be opened.
I want to bind pop up window with submit button and text box.
it should not be minimized when I click anywhere in parent window.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Try window.showModalDialog
|
|
|
|
|
thanks
It's working fine
You get the best out of others when you give the best of yourself.
|
|
|
|
|
How to close pop up window.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Hi to all,
migrating the prooject from vb to .net
In that project
Please tell me how i will able to convert the ocx control from
vb environment to .net i added in toolbox ; i added reference also
that control
i draw instance of that ocx on my web based project but in code behind i am not getting the events..
|
|
|
|
|
iam having two array strings now how can i comapare the two array length
|
|
|
|
|
Use Length property and compare.
string[] array1 = { "a", "b" };
string[] array2 = { "a", "b" };
if(array1.Length == array2.Length)
|
|
|
|
|
sir can we subtract the length ie array1.length-array.length
|
|
|
|
|
Yes, the "length" property returns an int
No matter how long he who laughs last laughs, he who laughs first has a head start!
|
|
|
|