|
Hi
I'm a beginner, but this should still be a simple task. I want to insert some data to my access database. I can run my project, but when I try to insert the data this error message appears: "Operation must use an updateable query"
This is my code:
OleDbConnection conInsertNews;
string strInserNewst;
OleDbCommand cmdInsert;
conInsertNews = new OleDbConnection( "PROVIDER=Microsoft.....);
strInsertNews = "INSERT INTO Test ( Name, Number, Adress ) VALUES ( 'Bob' , '8' , 'Str A' )";
cmdInsertNews = new OleDbCommand( strInsertNews, conInsertNews );
conInsertNews.Open();
cmdInsertNews.ExecuteNonQuery();
conInsertNews.Close();
Can anyone help me with this?
Thanks!!
Searcher
|
|
|
|
|
Okay i'm new to databinding and need to learn how to get information from the database, heres my code, howcome nothing gets returned?
<%@ Page language="c#" Codebehind="SalesLeadsLogin.aspx.cs" AutoEventWireup="false" Inherits="SalesLeadManagement.SalesLeadsLogin" %><br />
<%@ Import Namespace="System.Data" %><br />
<%@ Import Namespace="System.Data.OleDb" %><br />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" ><br />
<HTML><br />
<HEAD><br />
<title>Colley's Sales Lead Management</title><br />
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR"><br />
<meta content="C#" name="CODE_LANGUAGE"><br />
<meta content="JavaScript" name="vs_defaultClientScript"><br />
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema"><br />
<script language="C#" runat="server"><br />
protected void Page_Load(Object sender, EventArgs e)<br />
{<br />
OleDbConnection LoginConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\salesleadmgmt.mdb");<br />
OleDbDataAdapter LoginCommand = new OleDbDataAdapter("select * from UsrInfo" ,LoginConnection);<br />
<br />
<br />
DataSet LoginSet = new DataSet();<br />
LoginCommand.Fill(LoginSet, "UsrInfo");<br />
<br />
LoginGrid.DataSource=LoginSet.Tables["UsrInfo"].DefaultView;<br />
LoginGrid.DataBind();<br />
}<br />
<br />
<br />
</script><br />
</HEAD><br />
<body MS_POSITIONING="GridLayout"><br />
<form id="Form1" runat="server"><br />
<br />
<asp:DataGrid id="LoginGrid" style="Z-INDEX: 105; LEFT: 408px; POSITION: absolute; TOP: 256px"<br />
runat="server" BackColor="#6699CC"></asp:DataGrid></P><br />
</form><br />
</body><br />
</HTML>
|
|
|
|
|
Try replacing
fortyonejb wrote:
LoginGrid.DataSource=LoginSet.Tables["UsrInfo"].DefaultView;
with
LoginGrid.DataSource=LoginSet.Tables[0];
Also, are you certain that there is data in this table ?
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
Hi Sreejith
Thanks for your help. I have looked at your article, and although very interesting, does address my question entirely.
As well as iterating through my custom class collection, I would also like to have the Add, Remove and Item fucntions available to me too.
Is that something which can be easily incorporated into your Example2?
M
|
|
|
|
|
Enumerators only allow reading the data in the collection. Enumerators cannot be used to modify the underlying collection
An enumerator remains valid as long as the collection remains unchanged. If changes are made to the collection, such as adding, modifying or deleting elements, the enumerator can be invalidated and the next call to MoveNext or Reset can throw an InvalidOperationException.
But don't worry give me some hours, sure i will comeout with an idea.
Sreejith Nair
[ My Articles ]
|
|
|
|
|
Enumerators only allow reading the data in the collection. Enumerators cannot be used to modify the underlying collection
An enumerator remains valid as long as the collection remains unchanged. If changes are made to the collection, such as adding, modifying or deleting elements, the enumerator can be invalidated and the next call to MoveNext or Reset can throw an InvalidOperationException.
Sreejith Nair
[ My Articles ]
|
|
|
|
|
Hello,
How can I delete a string-value (NVarChar Type) in an easy manner from a Sql Database? I think the SQL Statements looks like - DELETE columnname FROM tablename WHERE Email=?
But how does look like the programm code?
Regards
mat
|
|
|
|
|
Hello,
I'm writing a custom DataGrid and in it i want to have some default actions occur. For example, what I have now, I cannot edit any rows (I only select full rows), multi-row selection is allowed, and the delete key will delete all currently selected rows.
But then there's this weird factor. When I press the up arrow key, I want my currently selected row to move to the previous one (the general case), and vice versa when I press the down key. But when I push Up, Down, Left, and Right (along with some other different keys), the KeyDown event handler for the DataGrid isn't called. Instead, the column style Edit event handler is called.
I thought I could just create a new event that would call an event handler from inside the Edit handler; however I would have no means to send off which key was pressed.
Does anyone know how to do this? I've been thinking about this and searching for what I need to override in order to do this, but to no avail. Can anyone help?
RockmanHero2003
A stitch in time is worth....two....in the bush
|
|
|
|
|
I have a Custom TextBox based on a Textbox. In my control I have a virtual method ValidTextBox. Now when I put my Textbox on a form I want to override the ValidTextBox method. I tried it but I got the error:"no suitable method found to override"
Can anyone tell me how to do this?
|
|
|
|
|
That is because the form is not a base class of the control. In order to override a method you must inherit from the class in which the method exists.
What is it that you want to do? I'm trying to think what you would want to do in a form that would require you to override a method on a control. The only thing I can come up with is handle some event. In this case a validation event. If you created an event that you handled in your form would you be able to introduce the same functionality that you want?
Do you want to know more?
Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.
|
|
|
|
|
The thing I want to do is validate the textbox. I created a ValidTaxtbox method that always returns true. The idea is that when you use the textbox, you write a new method for that textbox with the actual valid code.
|
|
|
|
|
Unless by "use" you mean you want to derive different types of ValidTextBox, then you really need to set up an event and handle the event in your form.
Do you want to know more?
Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.
|
|
|
|
|
Can you please explain that a bit?
I am very new at this and I just want to put the control on my form and write a validtextbox method each time I use it.
|
|
|
|
|
In your ValidTextBox class create an event, e.g.
public event EventHandler ValidateTextBox;
Then when you need to trigger the event you can write
this.ValidateTextBox(this, new EventArgs());
On your form you can then add a handler for the event, just like a handler for any other event with something like
myValidTextBox.ValidateTextBox+=new EventHandler(ObjectName_EventName); Normally, after the += I just usually let intellisense take over and I just hit tab twice, the first time to complete this statement, the second time to create a method stub for the event handler.
Now, I would guess that you don't want the default EventHandler because it doesn't allow you to pass much information - just the sender (the object that triggered the event), so you might want to set up a delegate. This sits outside the class
public delegate void ValidateDelegate(object sender, ValidateTextBoxArgs e); The ValidateDelegate here would replace EventHandler in the example above
You will also need to create a class that is derived from System.EventArgs, which above I've called ValidateTextBoxArgs
There are many source of information on this. If you need a step-by-step tutorial searching on the keywords delegate and event in msdn will likely turn up something useful - and I'm sure it will explain it better than I have done here.
Do you want to know more?
Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.
|
|
|
|
|
Thanks for explaining, I'll have a closer look.
|
|
|
|
|
Hello,
Now, I am developing the following tool.
This is download tool using .NET, WebClient.DownloadFile().
In IIS Server, I create virtual directory, set some files.
I execute this tools, but the error occuered.
Error occured ! System.Net.WebException: The remote server send the error. 404 not found
at System.Net.HttpWebRequest.CheckFinalStatus()
at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.HttpWebRequest.GetResponse()
at System.Net.WebClient.DownloadFile(String address, String fileName)
I am investiged the cause, so I found the solution. "make config file, the contents is the following (take '<' and '>')
configuration
system.net
defaultProxy
bypasslist
add address="192\.\..*" /
/bypasslist
/defaultProxy
/system.net
/configuration
But, I don't know where I set this config file. If you know it or some ideas, please advice me.
cheers,
yu-yu
|
|
|
|
|
Hi,
I'm not sure if what I want to do is possible but here goes.
I've written a stand alone application that queries a database through a series of stored procedures and displays the relevant data in a datagrid. Users can alter and exclude data as and when necessary but only one row at a time. Here's the thing, I want to add a checkbox column as the first column in the datagrid so that users can select all the rows they wish to exclude at once (all the exclude procedure does is move the rows from one table to another). Can it be done? I've had a few stabs at putting the column in but to no avail. Please can anyone out there point me in the right direction?
Much appreciated and thank you in advance.
Below is the code for formatting tables. I'll post any other code anyone wishes/needs to see.
private void formatData(DataSet ds)
{
label5.Text = ds.Tables[0].Rows.Count.ToString()+" row(s)"; //Row counter
// Clear DG tablestyle
dataGrid1.TableStyles.Clear();
// Apply tablestyles & set column widths
DataGridTableStyle dgStyle = new DataGridTableStyle();
dgStyle.MappingName = ds.Tables[0].TableName;
dataGrid1.TableStyles.Add(dgStyle);
dgStyle.GridColumnStyles[0].Width = 120;
dgStyle.GridColumnStyles[1].Width = 150;
dgStyle.GridColumnStyles[2].Width = 200;
dgStyle.GridColumnStyles[3].Width = 120;
dgStyle.GridColumnStyles[6].Width = 200;
}
|
|
|
|
|
Just as you're adding a DataGridTableStyle to DataGrid.TableStyles, actually add separate instances of DataGridColumnStyle-derivatives - like the DataGridTextBoxColumn or DataGridBooleanColumn (the checkbox column) - to the DataGridTableStyle. With what you're currently doing, the default for the column type is being used.
If you read the documentation for the DataGrid.TableStyles property you can see an example.
This really needs to be bounded to your data source, though. You could add a bogus DataColumn to your DataTable. You could also try just adding an unbounded column but, IIRC, the CheckBox won't be clickable. Perhaps defining your own DataGridColumnStyle derivative would help here.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
That's it, thank you very much. Much obliged to you.
|
|
|
|
|
Hi all,
Using the Key_Up or Key_Down event of a textBox i am trying to restrict the user from typing certain characters. I can do this in the Key_Press event using the KeyChar property and the Char.IsDigit().
i.e. if(char.IsDigit(e.KeyChar))
But in Key_Up or Key_Down you don't have the KeyChar property.
Any ideas?
Kev
|
|
|
|
|
|
I know that i can do that but i was hoping there would be a way of checking for a group of characters / keys i.e. All numbers, Full Stop, the Minus Sign etc.
Gues i'll just have to checkfor them all.
Thanks for your help
Kev
|
|
|
|
|
It's not as easy as with the Keypressed event but also you can check for group of characters. For example:
if (e.KeyCode < Keys.D0 || e.KeyCode > Keys.D9)
{
if (e.KeyCode < Keys.NumPad0 || e.KeyCode > Keys.NumPad9)
{
Take a look at the link I provided in my previous post.
www.troschuetz.de
|
|
|
|
|
Stefan,
Thanks for that, i wasn't aware that you could use the > and < operators
with KeyCodes and the Keys enumeration, guess i should have tried it 
On another point i thought that assigning e.Handled = true; in the Key Up
event would stop the character from being displayed, this works in the
KeyPress event but in the key up event it still types the character to the
screen.
Kev
|
|
|
|
|
I think it's not possible in the KeyUp event as even the example of the MSDN topic for KeyUp uses a boolean flag which gets checked in KeyPress event to determine whether the character should be displayed or not.
www.troschuetz.de
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
