|
Dear John !!
Im going to ask you a very stupid and simple question, please give me your valuable instructions...
dbo.Books is PK table
dbo.Category is PK table
dbo.BooksCategory is FK table
now im going to add a book into dbo.Books table. I got bookID=1001 and CategoryID=101.
my question is when should I insert data into dbo.BooksCategory table
1. insert data into dbo.books then dbo.bookscategory
2. insert data into dbo.bookscategory then dbo.books
is their anything i can do on my sql server 2005 database or i have to write a function to insert data into dbo.bookscategory from asp.net
waiting for a good instructions not like learn the basics
Sarfarj Ahmed
|
|
|
|
|
Please ask your Question in the Suitable Forum.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Thanks for your reply.
Im using asp.net and sql server 2005
i have design my database using sql server 2005 and writing code in asp.net (vb scipt)
Thanks
Sarfarj Ahmed
|
|
|
|
|
Sarfaraj Ahmed wrote: Dear John !!
This is a common forum. Donot Post your question to a particular person. Because Someone else in the forum may have a better solution.
Regards - J O H N -
|
|
|
|
|
Thanks John
I am not gonna do it again.
Im waiting for your instructions
Sarfaraj
Sarfarj Ahmed
|
|
|
|
|
You don't need to have a BooksCategory table. simplify it. Add a Foreign Key Column to the Books Table which will hold the CategoryID info.
Note: You have posted a SQL question in the ASP.NET forum.
Regards - J O H N -
|
|
|
|
|
books then bookscategory.
A simple way to test this would be to try and do it the other way around, you'll find it doesn't work. Note the word try here...
|
|
|
|
|
Hi friends
I am using following code in my page
Using(Employee objEmp=new Employee())
{
txt.EmployeeName.Text= .EmployeeName
}
This code is not working like as "With" for VB
can any one tell me how to use 'Using' in C#?
thanks
pAthAn
|
|
|
|
|
With and Using are two different things. When using 'using' the object created is disposed of when complete, and exists only for the duration of the statement. With is just a shortcut to save you typing the name of the object multiple times but has no other functionality.
|
|
|
|
|
|
hi,
i am developing an search engine based on indexing server.
in my application i give the search keyword at freetext in query.
it works well but problem is i want to search it as single phrase.but it search like multiple words.
its my query .
plz send reply asap.
string query = "Select Characterization,contents,DocPartTitles,Path,DocKeywords,DocTitle,Filename,Size,URL from Scope() where freetext('" + DDL_doctor.SelectedItem + "') order by filename ";
venkat
|
|
|
|
|
venky456 wrote: where freetext('" + DDL_doctor.SelectedItem + "') order by filename ";
DDL_doctor.SelectedItem.Text
Regards - J O H N -
|
|
|
|
|
sorry its also searching like multiple keywords not exact phrase.
regards
venkat
|
|
|
|
|
|
taltal81 wrote: without Javascript.....
Use VBScript[^]
Regards - J O H N -
|
|
|
|
|
i need to retrieve all the controls placed in the content place holder in content page ,so that i can get all the textboxes from them to clear their text when i click reset button
Suni
|
|
|
|
|
You can Navigate through the ContentPlaceHolder Control's and Check the control is of Type TextBox. You can write something like this...
For Each child As Control In c.Controls
If TypeOf child Is TextBox Then
CType(child , TextBox).Text = ""
End If
Next
Regards - J O H N -
|
|
|
|
|
JohnPrabhu ji!
i have tried your code but it's not working.
i got it solved this way..
.i put an empty panel
.using findcontrol()collected each wanted control and performed desired task on that control.
thank you for helping me.
Best Wishes.
SunithaNallana
|
|
|
|
|
I guess .NET Framework is Globalized and It works the same in all the .NET installed PC's all over the world. For some Unknown reason the same code works fine in my System.
Regards - J O H N -
|
|
|
|
|
Hi,
i have an input type="file" that attachment a file from my computer.
when i press on "send" button i want that this file will upload
i using with "mail.Attachments" element.
please help me ....
|
|
|
|
|
|
I guess he want to Upload the file to the Server before sending it as an attachment along with the mail.
Regards - J O H N -
|
|
|
|
|
Hello,
I want to get the value of checked node of Treeview with Check box.
Can someone throw some idea how to het the values of checked node of
Treeview in ASP.Net
Thanks
|
|
|
|
|
hi
protected void btnSubmit_Click(object sender, EventArgs e)
{
ArrayList CategoryArray = new ArrayList();
foreach (TreeNode tn in treeCategory.Nodes)
{
if (tn.Checked == true)
{
CategoryArray.Add(tn.Value);
}
CategoryArray = GetCategoryIDList(CategoryArray, tn);
}
}
public ArrayList GetCategoryIDList(ArrayList array,TreeNode tn)
{
foreach (TreeNode tchild in tn.ChildNodes)
{
if (tchild.Checked == true)
{
array.Add(tchild.Value);
}
GetCategoryIDList(array, tchild);
}
return array;
}
you get total node selected in CategoryArray
if you have any problem then tell me
Jintal Patel
|
|
|
|
|
Thanks for reply.
But i want to get the value as soon as user checked on node. if user checked second node firset checked node become unchecked and get the value of currently checked node.
|
|
|
|