|
Hi guys Good Morning,
I am collecting some datas from my enduser...,
Using textbox and gridview...,
if the datas only from textbox we can send that directly to storedprocedure and execute it,
But in my case some datas are coming from textbox and gridview(Using viewstate first i stored in to Gridview)...,
Now how to pass this text box values and one datatable records to stored procedure using SqlCommand parameter?,
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
|
|
Hi janakinandhu,
Thanks for ur reply,
Its not what i asked...,
Actual probs is i have some fields in textbox and some values in datatable...,
Now this all the values i have to pass it in to my stored procedure at a time,
and there it have to execute...,
Ex:
2 textbox values:
100, Tester
Datatable values:
ID Deg Year
100 MCA 2007
100 MBA 2005
Like this is there...,
Now this all the values have to pass to stored procedure at a time
& "The 100, Tester have to insert in to Table1, same time The ID,Deg,Year datatable values have to insert in to table2...,
This what i asked....,
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
Hi Friends,
I am planning to do certification in ASP.NET (70-528).
I need some queries regarding it. They are
1.IS it very tough to get it.
2.How expensive it is
3.Advantages abt doing this certificate
4.Is there any book/link/any other stuff is available for study
5.Can I get latest dump?
Waiting for reply
Thanks in advance
Ashwini
|
|
|
|
|
Get it
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
Hi,
How to add Link button control or hyperlink to table cell Dynamically .
i have to bind data to its text from database .
Regards
Rameez
thanks in advance
|
|
|
|
|
create TableRow, TableCell
Create LinkButton Class Object with Required Properties.
Add It to TableCell
then add the tablecell to TableRow
finaly add it to Table.
Hope now you can do it using code. if you have any problem with code the you can ask me !!
cheers,
Abhijit
|
|
|
|
|
Hi, thanks for looking
I have a website with two themes A and B, each with a css file and a skin file
A part of the website has theme A and another part theme B
The part with the theme A has a masterpageA for all contentpages
The part with the theme B has a masterpageB for all contentpages
I want to get rid off theme A and apply theme B to the whole site, for these i set the pages theme in the webconfig to theme B, but since masterpageA's layout is read from the css flie in theme A, i have to reference the stylesheet in themeA in the head section of masterpageA
This kind of works, but the masterpageA layout is taking SOME of the settings of masterpageB's layout (the ones with equal names in both css files) and ignoring the css file assigned in the head section
Whats the precedence?
Shouldnt the stylesheet assigned in the head section of the masterpage be applied?
Thanks in advance
Alexei Rodriguez
|
|
|
|
|
AlexeiXX3 wrote: Shouldnt the stylesheet assigned in the head section of the masterpage be applied?
you have to mainttion the Stylesheet name in only Masterpage and in content plceholder you juts mention the master page name. this will do for you.
in MasterPageA ->ThemeA and MasterPage2- > ThemeB . Now if a page has master page A then it will take themeA and same for other.
cheers,
Abhijit
|
|
|
|
|
How do you set the theme for a single masterpage? in the website?
Alexei Rodriguez
|
|
|
|
|
|
Capture the rowdatabound event of the gridview and use the following code:
Dim r As System.Data.DataRowView = e.Row.DataItem
If r Is Nothing Then Exit Sub
If r.Item("DateField") > Now.AddMonths(-3) Then
e.Row.BackColor = Drawing.Color.Blue
End If
Just translate it to c#
Alexei Rodriguez
|
|
|
|
|
Thanks Alexeixx3. I will try it. I appreciate it.
|
|
|
|
|
I converted the code over to c# as best i could, but i'm getting some errors. any ideas? The error is:
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS1061: 'System.Data.DataRowView' does not contain a definition for 'Item' and no extension method 'Item' accepting a first argument of type 'System.Data.DataRowView' could be found (are you missing a using directive or an assembly reference?)
Source Error:
Line 126: }
Line 127:
Line 128: if ((row.Item("expdate") > Now.AddMonths(-3)))
Line 129: {
Line 130: e.Row.CssClass = "expDomains";
& the code is:
if (e.Row.RowType == DataControlRowType.DataRow)
{
System.Data.DataRowView row = (System.Data.DataRowView)e.Row.DataItem;
if ((row == null))
{
return;
}
if ((row.Item("expdate") > Now.AddMonths(-3)))
{
e.Row.CssClass = "expDomains";
}
}
thanks.
|
|
|
|
|
try with [] instead of ():
row.Item["expdate"]
Alexei Rodriguez
|
|
|
|
|
Hello,
I wrote some usercontrols with the cascadingdropdownextender. The WebService and the UserControl resides in the dll (Action: Embedded Resource).
if i created a webapplication in asp.net 2.0 with VirtualPathProvider for load the UserControl and next for acessing the WebService, all work well.
In moss, when i construct a webpart the UserControl loads, but the webservie doesn't (Error Method 404). If i have instead controls wich not require webservice like CalenderExtender the webpart works like i expected. What could be wrong!!?
Thanks
|
|
|
|
|
I want to host website on my pc.
Does anyone know how to host website on my same pc ?
can any one suggest me any artical 4 that?
nirav patel
|
|
|
|
|
niravpatel01 wrote: I want to host website on my pc.
you need to deploy your web sites in IIS. for ther you need to create a Virtual Directory for your web sites in IIS and set the properties and you can run from any where in lan by the IP and virtual directory name.
you can find lots of article in google on that !!
cheers,
Abhijit
|
|
|
|
|
hai
install internet information service(iis) in your pc.it can be done by using ur xp cd.after that create a virtual directory in iis(right click on mycomputer-manage -services then take iis-default web site-tasks-create virtual directory) name it xxx and link it with ur root directory of ur website.
place ur website in intepub(it will be created when u install iis) and place it in wwwroot folder and then using IE type address localhost/xxx
|
|
|
|
|
Hi, Pls am new in crystal report in ASP.NET 2008 (usign VB codes). I created a CR using dataset (DataTable). Tested it with an SQL statement and it displays data. When I remove the direct where clause conditions to use parameter (because i will display the parameter as header information), it is giving me "Missing parameter values." Can someone help me. The code is below:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim ConnectionString As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
Dim conn As New OracleConnection(ConnectionString)
Dim MyDA As New OracleClient.OracleDataAdapter
Dim vacancyid As Integer = Request.QueryString("vacancyid")
Dim sql As String = ""
Dim cmd As New OracleCommand(sql, conn)
sql = "select a.VACANCY_ID,a.VAC_TITLE,a.PUBLISH_SDT,a.PUBLISH_EDT,a.MAX_SAL,b.OFFER_DT,b.SALARY "
sql = sql & " from vacancy a,offer_tbl b where a.COMPANY_ID=b.COMPANY_ID and a.VACANCY_ID=b.VACANCY_ID "
sql = sql & " and a.VACANCY_ID='" & vacancyid & "' and a.VAC_STATUS='F' order by VACANCY_ID"
cmd.CommandText = sql
cmd.CommandType = CommandType.Text
MyDA.SelectCommand = cmd
Dim myDS As New Vacancy_Test
MyDA.Fill(myDS, "DataTable1")
'====== Running the report directly with this statement works
' ''sql = "select a.VACANCY_ID,a.VAC_TITLE,a.PUBLISH_SDT,a.PUBLISH_EDT,a.MAX_SAL,b.OFFER_DT,b.SALARY "
' ''sql = sql & " from vacancy a,offer_tbl b where a.COMPANY_ID=b.COMPANY_ID and a.VACANCY_ID=b.VACANCY_ID "
' ''sql = sql & " and a.COMPANY_ID='1' and a.VACANCY_ID=1 and a.VAC_STATUS='F' "
' ''sql = sql & " order by VACANCY_ID"
'===================
Dim oRpt As New ReportDocument()
'Dim rpt As New ReportDocument
Dim reportPath As String = Server.MapPath("Vacancy-Test.rpt")
oRpt.Load(reportPath, OpenReportMethod.OpenReportByDefault)
Dim ParamFields As ParameterFields = Me.CrystalReportViewer1.ParameterFieldInfo
Dim p_vacancyid As New ParameterField
p_vacancyid.Name = "rpt_VacancyID" ' THE PARAMETER IN THE REPORT
Dim p_vacancyid_value As New ParameterDiscreteValue()
p_vacancyid_value.Value = Convert.ToInt32(vacancyid)
p_vacancyid.CurrentValues.Add(p_vacancyid_value)
ParamFields.Add(p_vacancyid)
'oRpt.DataDefinition.ParameterFields()
oRpt.SetDataSource(myDS)
CrystalReportViewer1.ReportSource = oRpt
End Sub
none
|
|
|
|
|
Use this function as per your need
private void setCurrentValuesForParameterField(ReportDocument rptDocument, string[] paramValue)
{
ParameterValues currentParameterValues = new ParameterValues();
ParameterFieldDefinitions parameterFieldDefinitions = rptDocument.DataDefinition.ParameterFields;
for (int i = 0; i < parameterFieldDefinitions.Count; i++)
{
ParameterFieldDefinition parameterFieldLocation = parameterFieldDefinitions[i];
currentParameterValues = parameterFieldLocation.CurrentValues;
ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue();
if (paramValue.Length - 1 >= i)
{
parameterDiscreteValue.Value = paramValue[i].ToString();
currentParameterValues.Add(parameterDiscreteValue);
parameterFieldLocation.ApplyCurrentValues(currentParameterValues);
}
}
}
|
|
|
|
|
Please am using VB code not C#. can someone help on VB Code
Thanks
Joe
none
|
|
|
|
|
|
Hi,
I had written a webservice..which is working fine. This webservice will reside in server.
Now if I have make this webservice work for multiple servers.
Right now Iam adding a webrefernce to my application which is consuming webservice.
if this webservice has to be utilised globally..then what I have to do?
If I have to host the same webservice on different servers that leads to waste memory..since in all web methods in all the webservices have same logic and same datatype.
1.To make the same webservcie work on mutiple servers....
2. How add web refernce globally through programatically
3. If to make the webservcie work globally what are the paarameters I have to pass for them?.
4. what is best mechanism to check whether server running or down?
Kindly help me in achieving above
So kindly tell me wat is the best way..
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
