eranby
Last Activity: Oct 7 '09, 02:07 PM
Joined: Aug 8 '07
Location:
-
this application is on my on pc, there are no administrators involved -
I need to connect to the sever and write to it from the c# application can the help me with that??Leave a comment:
-
mmm.. I guess there are many solutions , but I'm new to SQL server and the default permission is read only , I have searched a lot for an answer and didn't find any ,may you guide me how to implement one of those solutions ??
Thanks
EranLeave a comment:
-
writing permission on SQL server
Hi,
I connect the SQL server in my application using this code :
ConnectionStrin gSettings settings =
ConfigurationMa nager.Connectio nStrings["StockDB"];
con = new SqlConnection(s ettings.Connect ionString);
but I have no writing permission the database is for read only what should I do in order to add writing permission?
thanks
Eran -
bulk insert to SQL server table
Hi,
I'm trying to insert Datatable into my SQL table named TA100
I'm using this code :
...Code:public void refreshTable(DataTable freshData) { //con is the sql connection which is already open SqlBulkCopy copy = new SqlBulkCopy(con); copy.DestinationTableName = "TA100"; copy.WriteToServer(freshData); -
Hi ,
thank you for your help.
as I thought it was something very simple.
I added reference to System.configur ation and add Using System.configur ation to the code and used this code in order to connect the server :
ConnectionStrin gSettings settings =
ConfigurationMa nager.Connectio nStrings["StockDB"];
con = new SqlConnection(s ettings.Connect ionString);
it solve the problem :)
...Leave a comment:
-
I used the string you gave me and some others from the link but I'm still receiving the same error.
are the parameters in the string should be changed in my application or they are the same for every connenction?
and something about the error - it indicates that the server does not allow remote connection by default is it something in the configuration that I should set when adding the server?
thanksLeave a comment:
-
Hi,
sorry for the lack of information I'm new to SQL server hence my problem could be something very simple such as configuration issue that I'm not familiar with.
I used a string which I took from a web site I don't know if it is very helpful:
SqlConnection con = new SqlConnection(" user id=username;" +
"password=passw ord;server=serv erurl;" +
...Leave a comment:
-
connect to SQL server from c# program
Hi,
I want to add SQL server to my c# project ,I'm working on visual studio 2005
when i added the server i could not connect it.
can some one help me with it ?
thanks -
I have solve that one if any one need the answer ,contact me...Leave a comment:
-
Hi,
Thank you very much ,it was very helpful and solve my the problem!!
Eran...Leave a comment:
-
present sql query in data grid view c#
hi,
I'm using access db in my c# program I have a select query and I want to present
the result in data grid view ,I succeed doing that with this while loop
Code: ( c )
int i = 0,j=0;
while (dbReader.Read( ))
{
dataGridView2.R ows.Add();
dataGridView2[j, dataGridView2.R ows.Count - 1].Value = (string) [ dbReader.GetVal ue(0).ToString( ); j++;
... -
how to present sql query in data grid view c#
hi,
I'm using access db in my c# program I have a select query and I want to present
the result in data grid view ,I succeed doing that with this while loop
[CODE=c]int i = 0,j=0;
while (dbReader.Read( ))
{
dataGridView2.R ows.Add();
dataGridView2[j, dataGridView2.R ows.Count - 1].Value = (string) [ dbReader.GetVal ue(0).ToString( ); j++;
dataGridView2[j, dataGridView2.R ows.Count... -
thank you very much this was wath i was looking for helped my a lot : )...Leave a comment:
-
printing from right to left
hi
i want to print data grid view. the print in the page is fron right to left like i want by using the width feature of the document but the strings been written from left to right how can i print them from the spot that i choose in the document to the left and not to the right
thanks eran -
Hi
my application is not web application ,and by "webs" I did meant websites.
my program contain two windows forms which the user can feed data in to those forms and keep them in files for later reuse I would like to add form that include links to relevant websites so the user will be able to open those websites from the program
I hope this one will be easyer to understand
Thanks Eran...Leave a comment:
-
connect c# to web
I have c# program that contain few forms I want the user to be able to get links to some webs how can i connect the web from my program??
thanks
No activity results to display
Leave a comment: