|
hey
i am developing a web application using asp.net, but coding in C#.
i need to insert into my database (sql server 2000/access). how shud i do it.
i have two textboxes.. watever the user enters in it, it shud be added in a particular table.
Kunal Piyush
|
|
|
|
|
Hi there,
To achive this, you first need to know about SQL query (e.x: to insert data to DB, you have to know something like "insert into..." )
And you also have to know abt ADO.NET...you just simply google this...
<< >>
|
|
|
|
|
using System.Data.SqlClient; // don't forget this.
<br />
protected void btnSubmit1_Click(object sender, EventArgs e)<br />
{<br />
public string sqlConn = "";
Conn = new SqlConnection(sqlConn);<br />
<br />
a = TextBox1.Text;<br />
b = TextBox2.Text<br />
<br />
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();<br />
cmd.CommandType = System.Data.CommandType.Text;<br />
<br />
cmd.CommandText = "INSERT yourTableName VALUES ('" + a + "' , '" + b + "')";<br />
cmd.Connection = Conn;<br />
<br />
Conn.Open();<br />
cmd.ExecuteNonQuery();<br />
Conn.Close();<br />
}<br />
I have that in my code. Hope it works.
|
|
|
|
|
Hi everybody,
I have some documents created with asp.net and now i want to make 1 word document out of all the other documents.
Does anyone knows how I can do this??
|
|
|
|
|
Do you mean programmatically?
How about just opening each HTML document in Word, then combining them in Word?
|
|
|
|
|
Im new to asp.net and i probably wont even attemp this until i have quite a bit of experience on asp.net but this is my idea. Can I run a server as a media player not a media server. I would like to use a browser to connect to the server to play songs in my WMP media library (WMP SDK) on the server with a browser. the broswer will show the songs in a playlist, I can skip ahead or go back on songs, in short i want to do most things i can do in WMP. I would like to close the browser and reopen it later on and the same info will pull up where i can stop a song that is playing on the server or add on more.
Can the server do all of this itself or would i need to create an small media player app on the server that will take commands from the server via remoting? (browser -> server -> remoting to music app on server). I know all this can be one with a server and client app but i would like to try it on asp.net.
I know it sounds strange but its something i been thinking about.
modified 16-May-21 21:01pm.
|
|
|
|
|
Where can i find AJAX with ASP.NET 2.0 Tutorials (complete reference)...
|
|
|
|
|
See this[^] link to get started.
/ravi
|
|
|
|
|
|
|
hi there,
I'm having a couple of ImageButton s (dynamically created) on my aspx page. now they produce some border="0" attribute which I really don't want to have in my html, because it is not xhtml complient. how can I tell the ImageButton not to produce it. I'd spit out the raw html by my own and use a Literal instead, but I need the click event-handler of the ImageButton .
any help, any hints, any ideas?
thanks in advance!
/matthias
I love deadlines. I like the whooshing sound they make as they fly by. [Douglas Adams]
|
|
|
|
|
Hi matthias. If the problem is still, you might want to check the xhtmlConformance setting in the web.config. In addition, there are also a couple of options to take out this added attribute. You can override the Render method of the ImageButton, you can use the HtmlInputImage control instead .....
|
|
|
|
|
hi there,
thanks for your answer. the xhtmlConformance setting is a thing of .net 2.0 I guess. I'm still not sure whether to move to .net 2.0 (can't afford the upgrade of my VS professional in the first place and, secondly, I'm afraid that my projects stop working )
I was trying to override the Render method, but couldn't figure where the resulting html string went so I could attack it with a simple string.Replace() .
again, thanks for your patience.
/matthias
I love deadlines. I like the whooshing sound they make as they fly by. [Douglas Adams]
|
|
|
|
|
matthias s. wrote: I was trying to override the Render method, but couldn't figure where the resulting html string went so I could attack it with a simple string.Replace().
The sample code looks something like:
public class ExImageButton : ImageButton
{
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
string renderedHtml = GetControlRenderedHtml();
renderedHtml = RemoveBorderStyle(renderedHtml);
writer.Write(renderedHtml);
}
private string GetControlRenderedHtml()
{
StringWriter writer = new StringWriter();
HtmlTextWriter buffer = new HtmlTextWriter(writer);
base.Render(buffer);
return writer.ToString();
}
private string RemoveBorderStyle(string originalHtml)
{
string searchPattern = "border=\"0\"";
string replacement = "";
originalHtml = originalHtml.Replace(searchPattern, replacement);
return originalHtml;
}
}
|
|
|
|
|
hi there,
this explains more then a hundret sentences, and it solves my problem, too. thanks a lot and have a good day!
/matthias
I love deadlines. I like the whooshing sound they make as they fly by. [Douglas Adams]
|
|
|
|
|
matthias s. wrote: have a good day!
You too !
|
|
|
|
|
ok folks, i am currently using a dataset that pulls data from sql express server database (using the standard grid view etc in vs2005) however i wish to show several results in a label. can someone please make a project and send me the this so i can see the way in which this is performed.
Thanks in advanced.
|
|
|
|
|
I am trying to bind data to 2 datalist controls on page load event but getting a null pointer exception. I do not see anything wrong with the code. it just look like it doesn't like the bind. Has the page's lifecycle have anything to do with that? This is the code
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' Set the curent selection of list
Dim selectionId As String = Request.Params("selection")
Dim categoryId As Integer = CInt(Request.QueryString("CategoryID"))
' Obtain list of menu categories and databind to list control
Dim products As ASPNET.StarterKit.Commerce.ProductsDB = New ASPNET.StarterKit.Commerce.ProductsDB
MySubList.DataSource = products.GetSubCategories(categoryId)
MySubList.DataBind()
If Not selectionId Is Nothing Then
MyList.SelectedIndex = CInt(selectionId)
End If
'MyList.DataSource = products.GetProductCategories()
MyList.DataSource = products.GetProductMainCategories()
MyList.DataBind()
End Sub
|
|
|
|
|
Which line is causing the exception?
Are you sure that Request.QueryString("CategoryID") is returning a value?
Dim categoryId As Integer = CInt(Request.QueryString("CategoryID"))
|
|
|
|
|
Here is my problem
I want to print the contents of the datagrid c# in ASP.NET 2.0 but the constraints are:
1>When the user clicks the print button all the records till the end even the data is not visible to the user should get print.
2>It should print according to the page size that is the user tells how many records has to be dispalyed at a time on a webpage.
3>At every page the page header and footer sholud be displayed defined by the user
4>How to access the page footer and header programatically inorder to avoid to print the url at the end of the page.
Does any one knows the solution please reply it's urgent!
sunny
|
|
|
|
|
Hi sunny. That's quite a bit to ask for. To a large extent, it is the browser that controls printing (though CSS is catching up some with print media properties[^]. A real header/footer will be decided by the user through the browser, and I know no way to override that from a web page. For that matter, font-sizes and margins can be decided by the user making it virtually impossible for you to calculate where a new page will begin to apply your own header.
If you literally need that amount of layout control for your data, you might consider using a .pdf-creating component. You would have a print link/button on the page and the event handler for it would generate and serve the .pdf dynamically. Here's one open source component that looks promising:
http://sourceforge.net/projects/npdf/[^]
What I'm proposing is complex. But I don't see any straight ASPNET/HTML/CSS way to accomplish what you're describing.
And take this tip: a lot of CP members would pass on this post because you put "it's urgent" on it (I almost did). You probably don't want to sound demanding to a community of volunteers.
|
|
|
|
|
i am using a gridview in asp.net page to display records.
in the gridview i have inserted the in build delete command button to delete the records.
by default on clicking it does not ask for delete confirmation(just like confirm of javascipt). i want to ask for surity before
deleting the record how to do that.
Regards
|
|
|
|
|
|
What Is the "LITERAL" Control ?
MHF
|
|
|
|
|
The Literal control is a control that is used to output literal text.
The control:
<asp:Literal text="asdf"></asp:Literal>
will output this in the html code of the page:
asdf
---
b { font-weight: normal; }
|
|
|
|