|
Hi,
if you delete a column, the column will be deleted for all rows within the table. Set the value of the column for the specific row to NULL, if you want the value to be empty.
Regards
Sebastian
|
|
|
|
|
Well, how do you think you'd work out which column to delete ? The answer is, the ID exists to identify a record. So, write SQL to remove that row, based on the ID.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
string s = "insert into appointment values('"+TextBox1.Text+ "','" + TextBox2.Text + "' , '" + DropDownList2.SelectedItem.ToString() + "','" + DropDownList1.SelectedItem.ToString() + "',#"+Calendar1.SelectedDate.ToShortDateString()+ "#,#"+time.ToShortTimeString()+"#)";
am using this query to insert values.the prob is dat the date is being stored in mm/dd/yyyy format.but i want it in dd/mm/yyyy format.can anyone help me.am using microsoft access.
|
|
|
|
|
If you wrote this code for me, I'd fire you. It's unreadable, it shows an absence of any sort of thought or design, and anyone who wants to, can attack the database and erase it.
If you wrote proper database code, the dates would be stored as dates, not in any special format. Start by reading on SQL injection attacks. Then read up on how to write proper n-tiered applications. Finally, read up on database formats and data types. If you're writing code for work, I would suggest you're a good year away from being able to write anything that anyone with any sense would remotely consider paying for. If you're teaching yourself, then you are way out of your depth, take several huge steps back and learn a step at a time, instead of learning how to do everything wrong at once.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
can u give one example on that.
|
|
|
|
|
ankitjain1110 wrote: can u give one example on that.
You voted him 1 and still expecting help?
BTW, what examples are you interested in?
|
|
|
|
|
hey i found them.and i didnt vote him 1.may be that was an mistake.wat he said is true.i do believe the same.am very new in this field.but am trying hard.i wd always be happy to get advices from ma seniors.
|
|
|
|
|
OK.
1 - your variables should have meaningful names, not textbox1, etc
2 - your SQL should exist in a seperate dll, you should NEVER have SQL in the presentation layer
3 - because you pull your text directly from a textbox, a user can type valid SQL into that textbox, and thus create SQL that runs doing things you don't want. There are articles on SQL injection here on this site
4 - if you use a date/time datatype instead of a string, then the date will show in what ever format you ask for, because it's stored as a date, and not as a specific format.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
hi ,
I if u have written any blog on SQL injection please can u give us a link
Regards,
Amit Patel
|
|
|
|
|
I've never written one. The ones on the Code Project site are excellent, I have nothing to add to them.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi All
I have to implement audio as well as text captcha in ASP.net Using C#...
I have done imgae part.. but i am not able to implement Audio Captcha...
Pls Somebody Help Me..
Thanx & Regards
Sachin 
|
|
|
|
|
I suggest you buy a component. It's clear you don't know where to start with this.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
If i wanted to buy component then I havent posted this here.. if u know then tell otherwise Let me do my work.
|
|
|
|
|
I know. But, given that you haven't shown any signs of having thought about this at all, I'm not sure how it is that you expect to write an entire component to a commercial quality, based on a forum reply. How do YOU think it might work ? I'd imagine you need to either create MP3s for every letter you want to use, and generate some sort of playlist to stream the right sequence, or you need to write something that actually combines those MP3s into combinations to create a file to match each captcha.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi Chris...
I was just thinking that if sombody had gone through this he would have helped me by some code...
or give me some links where i can get some related solution...
However thnx any ways
|
|
|
|
|
Sachin Dubey wrote: I was just thinking that if sombody had gone through this he would have helped me by some code...
People will be helpful if whatever you are asking is trivial. But audio-captcha doesn't sound like a trivial job. I have already replied to you many days before with some possible ideas but you didn't bother to come back or think about those ideas. See here[^].
I'd suggest to keep your rude behaviour apart, read forum guidelines and understand how this forum works. With this attitude it is hard to get a reply for your questions from any online forums.
|
|
|
|
|
sir,
i have two tables and want to interchange values in eachother. How to implement state management in c#.
|
|
|
|
|
This question is very hard to answer.
1 - what sort of tables. In the database ?
2 - what do you mean by state management. Do you know what it means, or did you see it in a magazine ?
3 - what values do you want to swap and why ?
State management is build in, just use viewstate or the session. Perhaps if you can better explain what you need, we can give a more specific answer.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi ,
rj shukla wrote: i have two tables and want to interchange values in eachother
Please be Specific in Details Then U may get answers .
rj shukla wrote: How to implement state management in c#.
They are 3 types in state management u need to read in detail .The following link may help
http://www.csharphelp.com/archives/archive207.html[^]
Best Of Luck
If It Helps Mark it As answer
|
|
|
|
|
Code is below.
Problem is that when I delete 1st row, it gets deleted successfully.
When click happens, post back takes place. In page load, again resetting of dataset etc takes place. Now again dataset is populated with original values.
Please note that after deleting one row, I am not transferring the change back to connected data.
So how to achive it i.e. delete as many as rows in disconnected mode (without transferring any change to connected database).
IF I put all code of page load in (!Ispageback), it will not work because in deleting event, it will not find instance of ds etc.
More details:
Say 3 rows in dataset. I delete one. it is successful. post back takes place. In page load, again data set reinitialized, again filled up with 3 values (because after 1st deletion, we have not update the live data). So how to set the variables in such a way to achive it?
----------------------------------------------------------------
public partial class database : System.Web.UI.Page
{
OracleConnection oo;
String tt;
OracleDataAdapter adp;
DataSet ds ;
DataTable dt;
DataRow rw;
protected void Page_Load(object sender, EventArgs e)
{
oo = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
tt = "select emp_id,emp_name from ado";
adp = new OracleDataAdapter(tt, oo);
ds = new DataSet();
adp.Fill(ds, "ado");
GridView1.DataSource = ds;
if (!IsPostBack)
{
GridView1.DataBind();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int pos = e.RowIndex;
ds.Tables[0].Rows[pos].Delete();
ds.AcceptChanges();
GridView1.DataBind();
}
}
|
|
|
|
|
Once your page has done it's work ( such as deleting a row ), redirect it to itself. That way, if you refresh, it will reload the page without regenerating the event.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I am trying to implement your idea but does not work.
Can u give an example or 1-2 liner snippet of code.
Again summarizing my requirement:
1. I should be able to delete the rows one by one in disconnected mode.
2. After deleting one row from disconnected, I am not making any chnages to live(connected) database.
|
|
|
|
|
Oh - I see. You want to delete lines from visibility, but NOT from the database AT ALL ? How bizarre.
I guess you need to transfer your data to viewstate on first read, and then manipulate it from there, without ever referencing your data source again.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
i m using C#.net application with access database
i want display the data in grid view from multiple tables
like
the column should display "serial number" from table1 and second column sholud display "Name" from table2 and so on
any idea how to cater multiple tables with the gridview
thanks
|
|
|
|
|
swtlibra wrote: how to cater multiple tables with the gridview
You have to write a simple query for that, which will retreive data from two table based on join condition. Output of the query would be the source of GridView.
Thanks !
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
