|
Sorry I am very much new to .Net.. still i have doubt in this.. How can i insert those to Database.. i mean directly using loop or in some other way, as it is not compulsary to add values for all those 10 records.. In case if i enter values for only 2 records how can i retrieve those? Please help me..
Thanks & Regards,
Radha
|
|
|
|
|
just read reocrds on Datareader , now
while(datareader!=null)
{
_dr.items.Add(datareadr[index].text);
}
This is a concept , you can try this,
|
|
|
|
|
Thanks Abhijit, But i did like this.
_dr.DataSource = GetData();
...
public DataSet GetData()
{
...
}
What i asked is.. when i click Submit button, all the 10 rows are inserted even if i enter Data only for 2 rows. I am inserting records based on the table rows count.
protected void btnSubmit_Click(object sender, EventArgs e)
{
int j = tblRunTime.Rows.Count;
for (int c = 0; c < j; c++)
{
string query = " INSERT INTO Time VALUES( ";
query = query + " '" + Request.Form["_dr1" + c.ToString()] + "', ";
query = query + " '" + Request.Form["_dr2" + c.ToString()] + "', ";
query = query + " '" + Request.Form["text1" + c.ToString()] + "', ";
...
query = query + " '" + Request.Form["text8" + c.ToString()] + "', ";
query = query + " '" + f_date_b.Value + "'";
query = query + " )";
}
So, how i can solve this?
Please help me.
Thanks & Regards,
Radha
|
|
|
|
|
Let me know if you have still any problem !!! i will check on this on tomorrow!!!
Good night !!!
|
|
|
|
|
create a table at runtime add rows into it and afterwards add the controls into the cells.
similarly u can do the same to create the single or more then one rows at run time.
all u have to do is to find the table id at runtime.
Hope this will help u.
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
Yup, this is also a greate idea !!!
|
|
|
|
|
Thank u Pankaj.
I tried this. Even, one row is loaded by default. and if i click to add a new row, a new row is added but first row disappears.
ddlActivity.ID = "ddlActivity" + i;
ddlActivity.Visible = true;
...
Text1.ID = "Text1" + i;
Text1.Visible = true;
Text1.Width = 40;
...
Table tblForm = new Table();
tblForm.ID = "tblform";
TableRow r = new TableRow();
r.ID = "r" + i;
TableCell c8 = new TableCell();
TableCell c9 = new TableCell();
TableCell c = new TableCell();
TableCell c1 = new TableCell();
TableCell c2 = new TableCell();
TableCell c3 = new TableCell();
TableCell c4 = new TableCell();
TableCell c5 = new TableCell();
TableCell c6 = new TableCell();
TableCell c7 = new TableCell();
c8.Controls.Add(ddl1);
r.Cells.Add(c8);
c9.Controls.Add(ddl2);
r.Cells.Add(c9);
c.Controls.Add(Text1);
r.Cells.Add(c);
c1.Controls.Add(Text2);
r.Cells.Add(c1);
c2.Controls.Add(Text3);
r.Cells.Add(c2);
c3.Controls.Add(Text4);
r.Cells.Add(c3);
c4.Controls.Add(Text5);
r.Cells.Add(c4);
c5.Controls.Add(Text6);
r.Cells.Add(c5);
c6.Controls.Add(Text7);
r.Cells.Add(c6);
c7.Controls.Add(Text8);
r.Cells.Add(c7);
tblForm.Rows.Add(r);
plh.Controls.Add(tblForm);
I added controls like this. Did i miss anything here??
Thanks & Regards,
Radha
|
|
|
|
|
If u r adding the table dynamically , then keep in mind that the memory of that table control is not being washed out(I mean use the access modifier for the table control at the class level.)
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
Hi all
I have 2 Datatable
the fist (dtUser): have column UserID, Name, Address (10 rows)
the second(dtOrder): have column OrderID, UserID (5)
And 2 datatable haven't relationship
How can i "Select * from dtOrder A LEFT JOIN dtUser B ON A.UserID = B.UserID" in new datatable by Asp.net ??
|
|
|
|
|
Your question has nothing to do with ASP.NET.
However, you can define parent/child relationships between DataTables by using the DataRelation[^] class.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
SELECT *
FROM dbo.dtOrder INNER JOIN
dbo.dtuser ON dbo.dtOrder.UserID = dbo.dtuser.UserID
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
Hi,
I can't find a tutorial how to make server controls (if that is what I need to learn?).....
I want a control, which I can use on several projects (I can drag'n'drop from the toolbox).
The control I want, shoul be a web-based admin tool (to update users, delete users, create groups and so on) to the login control....
I tried for the past few days to look after such a control....but couldn't find it so now I want to build my own.....
But now I need a tutorial that explains me how to make such a control. Can anybody please help me?
Kind regards,
simsen 
|
|
|
|
|
Try to use Web Control ...(ascx File)...
|
|
|
|
|
Hi Abhijit,
Thanks for answering me
I don't know anything in creating controls only to use them......
Is a Web Control a user control (I have read that to use user controls in several solutions I have to implement the hole code in each solutions - this I don't want to do, I want a control which I can drag'n'drop from my toolbox whatever solution I am using)?
If I can this with a web control - do you have any links to an tutorial where it shows how to......witch database functionality?
Kind regards,
simsen
|
|
|
|
|
Just tell me what type of control do you want to create ?
|
|
|
|
|
I want a control that:
List all the users that is added when I use the buildin control login. It could be in a gridview (it doesn't matter what for me).... It should be possible to delete a certain user or to add a new user or to modify a user.
It is like - I want a web based control that adds the same functionality as you can get if you use the ASP.NET configuration in VS2005.
When I then drag'n'drop the control to a solution there should be a way to tell which database it is and so on.....
|
|
|
|
|
I forgot to say, that I need the tutorial in C#......I'm not good enough to translate it from VB.NET 
|
|
|
|
|
Hi,
I have a web application on a Windows XP box (IIS 5.1) which connects to SQL Server on a Windows 2003 box. I have Windows integrated security activated in IIS which is local. When I run my web application through browser it gives me the error: Login failed for user(null). Not a valid SQL Server connection. If I run the same Web app through VS 2005 it connects properly to the remote SQL Server database. Incidentally I log into my XP box in a global domain with a user credential who is having administrative privileges.
What is going wrong and what corrective action needs to be taken.
P.s. - This error has started creeping after I re-registered ASP.NET 2.0 in IIS using the aspnet_regiis utility as my IIS metabase had got corrupted. But I am not getting any clue as to why this should affect my SQL Server connectivity.
Thanx in advance
|
|
|
|
|
The machine where the sql sever is installed , there u gave the user name and password (unlike the window authentication)for ur sql server, Now check out ur connectionstring.I think , u did not mention the user name and passwod there.
and on more thing , I think , the window authentication mode on the machine where the vs.net is installed has nothing to do withe the sql server(on another machine). so write the connectiionstring , keeping in mind the configuration of that machine where the sql server is installed.)
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
Hi everybody, recently i have big problem of software development
i have needed you,my Question is that.
- How to call Dot net Web-Services in php/Java ?
from lucky.
|
|
|
|
|
There isn't anything particularly special about the webservices being done in .Net. You call them from your php/Java code the same way you call any other webservice.
|
|
|
|
|
i want to create a tree view but i have a problem in lines ****. what should i do? dose any body know?
TreeNode nodeProdDetail, nodeProdMaster;
nodeProdMaster = new TreeNode();
nodeProdMaster.Text = "Master1";
nodeProdMaster.Value = "1";
nodeProdDetail = new TreeNode();
nodeProdDetail.Text = "Detail1";
nodeProdDetail.Value = "1.1";
nodeProdDetail.NavigateUrl = "SomePage.aspx";
nodeProdMaster.Nodes.Add(nodeProdDetail); ****
TreeMenu.Nodes.Add(nodeProdMaster);
nodeProdMaster.Target = "main";
nodeProdMaster = new TreeNode();
nodeProdMaster.Text = "Master2";
nodeProdMaster.Value = "2";
nodeProdDetail = new TreeNode();
nodeProdDetail.Text = "Detail2";
nodeProdDetail.Value = "2.1";
nodeProdDetail.NavigateUrl = "SomeOtherPage.aspx";
nodeProdMaster.Nodes.Add(nodeProdDetail);****
TreeMenu.Nodes.Add(nodeProdMaster);
|
|
|
|
|
perhaps u shuld use it nodeProdMaster.Add(nodeProdDetail) because nodeProdMaster.Nodes is null yet.
sepel
|
|
|
|
|
Flash File working fine in FF... but not working in IE.Any sugession will be helpful...
Thanks in Advance...![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
Erasers are for people who are willing to correct their mistakes.
|
|
|
|
|
Maybe you have an issue with the flash plugin in IE? Maybe it isn't installed in IE?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
