|
My codes is shown below. Hopefully it should create a dataset. But how do I create a dataset in code using these values. Something like
<br />
Dim NewDataSet AS Dataset MadData.Cusomer_Lookup(Parameters here)
?
Public Class MadData<br />
'get application settings<br />
<br />
<br />
<br />
<br />
Public connectionString As String = ConfigurationManager.ConnectionStrings("MADConnectionString").ConnectionString<br />
<br />
Public Function Customer_Lookup(ByVal CustomerType As Integer, ByVal CustomerForename As String, ByVal CustomerSurname As String, ByVal LimitedTradingName As String, ByVal NonTradingName As String, ByVal AddressMobile As String, ByVal Records As Integer, ByVal Query As String) As DataSet<br />
<br />
'get the entity name to use for the DataSet table<br />
Dim dbConnection As New SqlConnection(connectionString)<br />
Dim dbDataSet As New DataSet<br />
<br />
Try<br />
'Create Command object for sp<br />
Dim dbCommand As SqlCommand = New SqlCommand("Customer_Lookup", dbConnection)<br />
dbCommand.CommandType = CommandType.StoredProcedure<br />
<br />
'input parameter variables - CustomerType<br />
Dim dbParameter As SqlParameter = dbCommand.Parameters.Add("@CustomerType", SqlDbType.Int)<br />
dbParameter.Direction = ParameterDirection.Input<br />
dbParameter.Value = CustomerType<br />
<br />
'input parameter variables - CustomerForename<br />
Dim dbParameter1 As SqlParameter = dbCommand.Parameters.Add("@CustomerForename", SqlDbType.VarChar)<br />
dbParameter1.Direction = ParameterDirection.Input<br />
dbParameter1.Value = CustomerForename<br />
<br />
'input parameter variables - CustomerSurname<br />
Dim dbParameter2 As SqlParameter = dbCommand.Parameters.Add("@CustomerSurname", SqlDbType.VarChar)<br />
dbParameter2.Direction = ParameterDirection.Input<br />
dbParameter2.Value = CustomerSurname<br />
<br />
'input parameter variables - LimitedTradingName<br />
Dim dbParameter3 As SqlParameter = dbCommand.Parameters.Add("@LimitedTradingName", SqlDbType.VarChar)<br />
dbParameter3.Direction = ParameterDirection.Input<br />
dbParameter3.Value = LimitedTradingName<br />
<br />
'input parameter variables - NonTradingName<br />
Dim dbParameter4 As SqlParameter = dbCommand.Parameters.Add("@NonTradingName", SqlDbType.VarChar)<br />
dbParameter4.Direction = ParameterDirection.Input<br />
dbParameter4.Value = NonTradingName<br />
<br />
'input parameter variables - AddressMobile<br />
Dim dbParameter5 As SqlParameter = dbCommand.Parameters.Add("@AddressMobile", SqlDbType.VarChar)<br />
dbParameter5.Direction = ParameterDirection.Input<br />
dbParameter5.Value = AddressMobile<br />
<br />
'input parameter variables - Records<br />
Dim dbParameter6 As SqlParameter = dbCommand.Parameters.Add("@Records", SqlDbType.Int)<br />
dbParameter6.Direction = ParameterDirection.Input<br />
dbParameter6.Value = Records<br />
<br />
'input parameter variables - Query<br />
Dim dbParameter7 As SqlParameter = dbCommand.Parameters.Add("@Query", SqlDbType.VarChar)<br />
dbParameter7.Direction = ParameterDirection.Input<br />
dbParameter7.Value = Query & "%"<br />
<br />
'open the Connection; run the sp; transform to a DataSet<br />
Dim dbDataAdapter As SqlDataAdapter = New SqlDataAdapter(dbCommand)<br />
dbDataAdapter.Fill(dbDataSet)<br />
<br />
Catch ex As System.Exception<br />
<br />
Throw ex<br />
<br />
<br />
Finally<br />
'tidy up<br />
dbConnection.Close()<br />
dbConnection.Dispose()<br />
<br />
End Try<br />
<br />
Return dbDataSet<br />
<br />
End Function<br />
<br />
End Class
|
|
|
|
|
You're missing an equals sign, but yes.
|
|
|
|
|
|
|
hi vasudevan and thanx for your reply.
It's not what i've been searching for, but surely it puts me on he right direction. Anyway, i'm not an Ajax programer and examples like you gave me helps a lot to learn. And nice scripts too must say.
cheers!
"I hated myself... no, I hated my place in the world" - From Jerry Maguire
|
|
|
|
|
how many columns datagrid hav ??
|
|
|
|
|
The screen real estate, good user experience of the application and Memory alone would dictate this limit right?
|
|
|
|
|
Hi,
I'm wondering how to do this, I'm working on the on a datagrid and I'm using windows authentication. I managed to get username on to a login form, but I want it to be stored into the database.The code of web config looks like:
authentication mode="Windows"
identity impersonate="true"
And the Login page looks like on(Page_load):
Response.Write(Page.User.Identity.Name);
Thanks.
|
|
|
|
|
What exactly is ur problem??
If u want to get the windows login name then use:
HttpContext.Current.User.Identity.Name
or else tell us what is the exact problem.
All the Best...
|
|
|
|
|
Thanks,
I want is when any one uses the website the Windows Login name should appear in a particular datagrid column automatically.
Thanks.
|
|
|
|
|
Your problem is solved or not????
|
|
|
|
|
Not yet solved. When I try using: HttpContext.Current.User.Identity.Name; I get error: Only assignment, call, increment, decrement, and new object expressions can be used as a statement.
Thanks
|
|
|
|
|
varshavmane,
I think this will help anderstand my problem is there a way The windows login can be saved automatically into database whenever a user uses the website? since I'm working with datagrid.
Thanks
|
|
|
|
|
Hi
I am using the asp:hyperlinkField in asp.net For this I am writing the following code in .aspx page
<asp:hyperlinkfield navigateurl="~/KB/KB_Detail.aspx?id=<%#DataBinder.Eval(Container.DataItem, "PK_KnowledgeBaseID") %>" datatextfield="s_Title" headertext="Title">
But it is not working properly.Please tell me the problem
Regards
Karan
|
|
|
|
|
When you post code in a forum you need to check the box below that says Ignore HTML tags in this message (good for code snippets)
Otherwise the code gets removed and we won't see it.
Thanks,
Ben
|
|
|
|
|
How do you access a template field in the gridview and assign it to the string, especially in the rowcommand function
nzibi
|
|
|
|
|
wrote:
TemplateField contains ItemTemplate, which has id. You can find that control in code behind using FindControl method.
Here[ ^] is some code snippets for same.
Knock out 't' from can't,
You can if you think you can
|
|
|
|
|
Please help me.I have declared my variables
***************************
Public Sub addTimesheet(ByVal IdNumber As String, ByVal ProjectName As String, ByVal ProjectMember As String, ByVal ClientSite As String, ByVal ProjectManager As String, ByVal Occupation As String, ByVal WeekNumber As Integer, ByVal Day As String, ByVal Hour As Integer, ByVal Description As String)
Dim Sql As String
Dim obj As Datalayer.Database = New Datalayer.Database
Sql = "insert into TimeSheet (Id_Number,Project_Member,Project_Name,Project_Manager,Hour,Day,Description,Client_Site,Occupation,Week_Number)" & _
" Values('" & IdNumber & "','" & ProjectName & "','" & ProjectMember & "','" & ClientSite & "','" & ProjectManager & "','" & Occupation & "', '" & WeekNumber & "','" & Day & "','" & Hour & "','" & Description & "')"
obj.Execute(Sql)
'addTimesheet = obj.GetDataset(Sql)
'obj.Close()
'Exit Sub
*******************************
Gives me this error
Conversion failed when converting the varchar value 'Select Project Manager' to data type int.(Pointing this query statement) lngRecords = cmdQuery.ExecuteNonQuery()
End Sub
******************
In my AddEntryButton
Dim Obj As Businesslayer.TimeSheet = New Businesslayer.TimeSheet
Obj.addTimesheet(txtIDNo.Text, cmbProjectName.SelectedItem.Text, cmbProjectMember.SelectedItem.Text, cmbClientSite.SelectedItem.Text, cmbProjectManager.SelectedItem.Text, cmbOccupation.SelectedItem.Text, txtWeekNo.Text, cmbDays.SelectedItem.Text, txtHours.Text, txtDescription.Text)
*******************
What might be the Problem(explain it to me please)
oga m
|
|
|
|
|
Check the datatype of the data what you are sending from front end to the database.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Your code will fail with this sort of error whenever your strings contain a single-quote (e.g. "Fred's Project"). Try searching for "SQL Injection" or look at Parametorized SQL[^].
Regards
Andy
|
|
|
|
|
i want to display date in a datagrid column. To fill that datagrid i am filling data to a dataset and i am assigning that data set to datagrid.what my problem is that i am not able to display only date in that column.the time also is displaying with date.if i want to display time only then date also is coming along with time.
please help me to solve this problem
saravanan
|
|
|
|
|
use the ToShortDateString() method...
DateTime dt = new DateTime();
string str = dt.ToShortDateString();
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
if you are pulling the data from database, try to do the date formating in sql server like
CONVERT(VARCHAR,column name,101)
|
|
|
|
|
Saravanainit_2004@yahoo.com wrote: display date in datagrid instead of date and time
1. Use formatter for DateTime fields.
2. mydate.ToString("dd/mm/yyyy"), mytime.ToString("hh:mm tt")
mydate and mytime are variables of DateTime.
Use the TemplateField for DateTime fields in GridView and override RowDateBound method of GridView and use the FindControl to find the label in GridViewRow.Assign the formated date to that label. That's it.
Knock out 't' from can't,
You can if you think you can
|
|
|
|
|
Try:
<%# Convert.ToDateTime(DataBinder.Eval(Container.DataItem, "YourDateTimeFieldHere")).ToString("MM/dd/yyyy") #>
Hope that helps.
Ben
-- modified at 21:10 Thursday 22nd March, 2007
|
|
|
|