|
I have written this and the data don't want to enter in my Microsoft Access database.
What is wrong????????????
using System.Data.OleDb;
private void Button1_Click(object sender, System.EventArgs e)
{
string SQL;
OleDbConnection connection = new OleDbConnection
(@"Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=" + Server.MapPath("baza.mdb"));
OleDbDataAdapter sql = new OleDbDataAdapter("select * from Korisnici", connection.ConnectionString);
connection.Close();
connection.Open();
SQL = @"insert into Users ([UserID],[Name],[Surname],[Address],[Phone],[YearsOld],[UserName],[Password],[Privilegy]) VALUES (";
SQL = SQL + @"'"+TextBox9.Text+"'"+"'";
SQL = SQL + @"'"+TextBox8.Text+"'"+"'";
SQL = SQL + @"'"+TextBox7.Text+"'"+"'";
SQL = SQL + @"'"+TextBox6.Text+"'"+"'";
SQL = SQL + @"'"+TextBox5.Text+"'"+"'";
SQL = SQL + @"'"+TextBox4.Text+"'"+"'";
SQL = SQL + @"'"+TextBox3.Text+"'"+"'";
SQL = SQL + @"'"+TextBox2.Text+"'"+"'";
SQL = SQL + @"'"+TextBox1.Text+"')";
OleDbCommand myCommand = new OleDbCommand(SQL, connection);
myCommand.ExecuteNonQuery();
connection.Close();
Response.Redirect("WebForm1.aspx");
}
Vasildb
|
|
|
|
|
We'll a few things..here's a start:
1. The line "OleDbDataAdapter sql = new OleDbDataAdapter ..." is unused and can be removed.
2. You're not validating the value of your textboxes. So, here's a list of all the problems you're going to have from that:
a) SQL injection
b) A single tick mark could cause your query to fail.
c) Invalid types could also cause your query to fail.
3. Your "@" is unneccessary if you're trying to modify how the compiler is treating the C# string immediately following.
4. Opening/closing of your connection should occur as close together as possible. So, you should move your open just before your call ExecuteNonQuery.
5. Why are you closing the connection right after your creation of the OleDbDataAdapter? It's unneccessary.
6. And the one million dollar answer that you wanted, your second set of tick marks (') for each value should be commas rather than tick marks.
For future cases, I would suggest looking at the string you're building up (if you indeed choose to keep building dynamic SQL like that) in the debugger. I would highly suggest either creating a parameterized SQL string or a stored procedure (my recommendation) for such cases.
Good luck.
|
|
|
|
|
Hi!
I have MS SQL Server 2005 installed on my system. I am using NHibernate to interact with my database named 'BRUSDB'. I have set the following configuration for nhibernate:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section
name="nhibernate"
type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0,Culture=neutral, PublicKeyToken=b77a5c561934e089"
/>
</configSections>
<nhibernate>
<add
key="hibernate.connection.provider"
value="NHibernate.Connection.DriverConnectionProvider"
/>
<add
key="hibernate.dialect"
value="NHibernate.Dialect.MsSql2005Dialect"
/>
<add
key="hibernate.connection.driver_class"
value="NHibernate.Driver.SqlClientDriver"
/>
<add
key="hibernate.connection.connection_string"
value="server=server; database=BRUSDB;user=sa;pwd=sorcim"
/>
</nhibernate>
</configuration>
when i run the program The type initializer for 'NHibernate.Cfg.Configuration' threw an exception:
'System.TypeInitializationException'
at line:
Configuration cfg = new Configuration();
If any one has know then kindly guid me.
Thanks.
|
|
|
|
|
This indicates that your config file is invalid. You've probably forgot to add a closing XML tag or added an extra one somewhere. Unfortunately I can't tell, because your post interpreted the < and > tags as HTML tags.
|
|
|
|
|
current_item_data_row["MenuPrice"] = Convert.ToDecimal( targetRow["MenuPrice"] ) * Convert.ToInt32( this.textBox_OtherQuantity.Text ); /*******/
How can I change this so that 19.9 will be displayed at 19.90 (no $ pleasE)
Thanks 
e
|
|
|
|
|
Why not display it as a string and use format?
|
|
|
|
|
because the dataset is formatted as a decimal, and then the dataset is bound to the datagrid. Is there is a way to easily format the datagrid to show string.
|
|
|
|
|
Change the DataBinder.Eval(Container.DataItem, "YourFieldName") to either a server side function or inline.
|
|
|
|
|
Hello,
I have the following constants:
<br />
public static string DOCUMENT_NAME_PARSE_EXPRESSION = @"(AG_DOCNAME)(?innerDocName.*?)(AG_DOCNAME)";<br />
public static string DOCUMENT_NAME_INNER_EXPRESSION = @"${innerDocName}";<br />
I have the string that contains something like that:
..some text here .....AG_DOCNAMEtestAG_DOCNAME......some text here...
Now I pass that string into a function:
<br />
private bool ReplaceValueInHTML (string context, string newValue)<br />
{<br />
Regex expression = new Regex(DOCUMENT_NAME_PARSE_EXPRESSION, RegexOptions.IgnoreCase | RegexOptions.Multiline | RegexOptions.Singleline | RegexOptions.Compiled | RegexOptions.ExplicitCapture);<br />
<br />
Match match = expression.Match(context);<br />
if (match.Success)<br />
{<br />
}<br />
else<br />
{<br />
return false;<br />
}<br />
return true;<br />
} <br />
What I am trying to do is this: After I find that substring (AG_DOCNAMEtestAG_DOCNAME), I want to replace "test", with the newValue. And after user expression.Replace(context, match), or something like that. Proble is I can't replace that "test" value. Anybody has any ideas?
Thank you.
|
|
|
|
|
Use group patterns.
Example:
Regex regex = new Regex( @"\sFrom\:[\s]+\""(?<from>(.)+)\""\s+To\:[\s]+\""(?<to>(.)+)\""\s+Subject\:[\s]+(?<subject>(.)+)Date\ s|\S)+\sBody\:[\s]+(?(.)+)\r\n");
Match match = regex.Match(message);
txtFrom.Text = match.Groups["from"].ToString();
txtTo.Text = match.Groups["to"].ToString();
txtSubject.Text = match.Groups["subject"].ToString();
txtBody.Text = match.Groups["body"].ToString();
|
|
|
|
|
Hello,
I got a c# app that controls a website through mshtml. I'm trying to execute a javascript that for some reason will not execute through the standard:
IHTMLWindow2 win = HTMLDoc.parentWindow;
win.execScript(theScript, "JScript");
I have found that if I manually enter the jscript into the IE address bar and hit GO, then it will run.
However I have tried the Navigate and the window.open(js) and these do not work either.
Any clues out there as to how one would insert a jscript into the IE address bar and click go through c#?
Help appreciated, thanks in advance!
PhrankBooth
|
|
|
|
|
have you tried RegisterClientScriptBlock?
|
|
|
|
|
|
You waited 6 hours 22 minutes and then you got sufficiently impatient that you posted again while your original post is still on the first page of the forum. We answer questions voluntarily so some patience would be nice.
hdv212 wrote: does any body can show me how to use Sql Transactions in DataRow ?
SqlTransaction is for transacting multiple queries on a SQL Server not the DataRow.
|
|
|
|
|
There are several apps across our company that need to access a WebService that is really a SQL Server 2005 SOAP endpoint. A domain service account was created for it so we wouldn't have to enable access for every single user. Initially, this user was setup as being allowed to logon to the server that SQL Server 2005 was running on. However, when we tried to access it, nothing worked. After monkeying around for a few days, in order to make it work we finally had to enable this service account logon priviledges to the computer calling the webservice. It turned out we didn't even need logon priviledges to the server.
This seems completely backwards to everyone here, and will be a real pain to administer if it is the case.
Here's some code that's similar to what we're doing to access it:
private DataSet GetInformation()
{
wsSQL service = new wsSQL();
service.Credentials = new NetworkCredentials("user", "pass");
return service.CallWebMethod();
}
The above code works only if the "user" has logon access to the local computer. From the looks of how this works, it's almost as if the NetworkCredentials uses the local computer to log onto the network, then passes those credentials on. Is this correct? If so, is there anyway to use the domain user to logon to the server and use those credentials?
-----
In the land of the blind, the one eyed man is king.
|
|
|
|
|
Hi Guys,
Question please, how do you skip to a particular node on the tree when the tree loads?
Thanks in advance.
sasa
|
|
|
|
|
Have a guess. Go on... What do you think will select a particular node? Yup, it's SelectedNode
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
What environment are you using? Windows, Web? You can't use Tree.SelectedNode = ???
only two letters away from being an asset
|
|
|
|
|
I have tried this and it doesn't work for some weird reason, basically what I am doing is when a node is modified, e.g inactivated the imageindex is changed and hence I tried refreshing by reloading the tree to show the new image index, it does show the new imageindex but until I expand the tree and go to that node by clicking my way through. Basically, I want to reload the tree and jump back to the node where I was before the reload.
Please help!!!
sasa
|
|
|
|
|
Well then, that's a bit different then just selecting a node. 
There is no way that I'm aware of to expand the tree down to the node in question without actually calling expand on the parents of that node.
only two letters away from being an asset
|
|
|
|
|
hi all.
I want to write and create a scrapbook ( messageboard ) in C# ( asp.net) and my database is sqlserver 2000
I have problem in writing it. Can anyone help me and give me the code in C# ...?
I have created the table in database and the program is connected to database . I know I need to insert text(messsage) into database but how can I SHOW the posted message in the page...??
I want to show all the posts and the last post in the page...like here ...
please help me.
thanks alot.
|
|
|
|
|
sanaziuse wrote: I want to write and create a scrapbook ( messageboard ) in C# ( asp.net) and my database is sqlserver 2000
I have problem in writing it. Can anyone help me and give me the code in C# ...?
I have created the table in database and the program is connected to database . I know I need to insert text(messsage) into database but how can I SHOW the posted message in the page...??
I want to show all the posts and the last post in the page...like here ...
This is all far too vague - we don't know anything about the architecture of your application, the data model you are using etc. Your question is too general and so any meaningful answer would likely take many pages.
You have to be specific. What exactly do you need help with?
|
|
|
|
|
hi.
I need the C#.net code for scrapbook.
My database is sqlserver2000 and using visualstudio.net 2003
my scrapbook should be like this :
it has a textbox for writing the topic
a textbox for writing name
a textbox for writing the message.
a user writes a message in the scrapbook(textbox) of his friend and click on the button to send.after that,the user can see his message and also other messages in the scrapbook...
I know how to insert the data in table(database) but I dont know how to show the last and also the previous messages in the page...
thanks alot.
|
|
|
|
|
sanaziuse wrote: I need the C#.net code for scrapbook.
sanaziuse wrote: I want to write and create a scrapbook
So who now, you or we?
modified 12-Sep-18 21:01pm.
|
|
|
|
|
I am trying...but i just could insert into database...so please help me with entire code...or give me the whole code for scrapbook
thank you
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
