ASP.NET

Re: Select Statement problem

27-Jul-07 17:46

You seem to have not checked 'Ignore HTML tags in this message (good for code snippets) and htmlised half your code.

One way to do this is to set the Text to get it's value from calling a method, or you could just use the code inline, in a server code block. This works the same way as the DataBinder.Eval, just replace it with Session["mykey"].ToString() or something ( a method which checks if the value is null is obviously better )

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Select Statement problem

ASPnoob27-Jul-07 16:14

ASPnoob

27-Jul-07 16:14

Hi, in the code below the IF statement is used for multiple selection of list items in a list box. The select statement is supposed to select the CarID and the Model fields From the table CarTB, where the value of the field Make equals the text value of the list item in my list box that has been selected.

Dim DS As New DataSet
  For i = 0 To CarNamesDL.Items.Count - 1
   If CarNamesDL.Items(i).Selected Then 
     BConn = New OdbcConnection("Driver={MySQL ODBC .51Driver};Server=myServer;Database=CarCompaniesDB;User=myUserassword=myPass;Option=3;")
     DBCommand = New OdbcCommand("SELECT CarID, Model From CarTB where Make = '" & CarNamesDL.Items(i).Text & "'", DBConn)
    End if
  Next

I get the error "Character constant must contain exactly one character" and visual studio is saying that the select statement is the cause. Please take a look and explain to me what I did wrong in the select statement. Thank you in advance for your help.

Christian Graus27-Jul-07 17:49

copy file to network folder

27-Jul-07 17:49

Apart from not protecting yourself from SQL Injection ?

ASPnoob wrote:
User=myUserassword=myPass;

I assume this should be User=myUser;Password=myPass; ??

Does MySQL use single quotes for strings ? Perhaps it's assuming that ' is for a char, and so it's complaining that there's more than one character in there ? MySQL sucks.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Dpriya27-Jul-07 16:12

Dpriya

27-Jul-07 16:12

Hi ,
I'm using a web service to copy file to a network folder restricted to a specififc username & pwd.
I tried
<identity impersonate="treu" username="domain\user" password="pwd">
It did not work.
Thanks in advance
Priya

Re: copy file to network folder

Dpriya27-Jul-07 16:36

Dpriya

27-Jul-07 16:36

Hi,

Priya again
I tried,

Re: copy file to network folder

Christian Graus27-Jul-07 17:51

Re: copy file to network folder

27-Jul-07 17:51

What web service ? What did you try ? How does it not work ? What advice were you hoping for, based on this vague post ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Dpriya29-Jul-07 8:46

Dpriya

29-Jul-07 8:46

Hi,

I'm using .NET web service. I wanted my web service to run on specific user account. When i tried <identity impersonate="true" username="<domain\user"> password = <password> > in web.config it does not work.

Pls advise.
thanks,
Priya

How to show images in the Datagrid

Kurian_Kurian27-Jul-07 16:00

Kurian_Kurian

27-Jul-07 16:00

Hi.I want to show the images in the datagrid.i want to bound the datasource into datagrid.the method i used for retrieving images is written down.using this method am getting other fields.i add one template column in the datagrid and add one image control in that item template,the template column datafield given this sql image column name.sql image datatype is Image.i want to show all the images in the datagrid.

public static DataSet getImages()
{
DataSet ds = new DataSet();

using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("SPOC_PHOTOS_SELECT", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataAdapter da = new SqlDataAdapter())

{
da.SelectCommand = cmd;
try
{
conn.Open();
da.Fill(ds);

return ds;
}
catch (Exception e)
{
throw e;
return null;
}
finally
{
conn.Close();
}
}
}
}

IIS gets Access Forbiden error [modified]

beatles169227-Jul-07 12:19

beatles1692

27-Jul-07 12:19

Hi I'm trying to write a web project using ASP.Net 2.
I have IIS 5.1 and ASP.Net 2 installed.
I've registered asp.net in my IIS but every time I want to browse to a directory under my IIS default web site I get a 403 error that says "You are not authorized to view this page."
I tried to browse iisstart.asp under default web site using IE 6 and I got this error:

Error Type:
Microsoft VBScript runtime (0x800A0046)
Permission denied: 'GetObject'
/localstart.asp, line 40

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; FDM; .NET CLR 2.0.50727)

Page:
GET /localstart.asp

I'm totaly confused about this error and I can't understand why it happens.
Please help me.
Thanks a lot.

-- modified at 18:35 Friday 27th July, 2007

Re: IIS gets Access Forbiden error

beatles169227-Jul-07 12:46

beatles1692

27-Jul-07 12:46

Here is a solution that i found searching the Net
http://support.microsoft.com/kb/251361

Re: IIS gets Access Forbiden error

Paul Conrad27-Jul-07 19:40

adding and removing table rows dynamically

27-Jul-07 19:40

Sounds like permission problem...

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

jojoStoneHead27-Jul-07 10:57

jojoStoneHead

27-Jul-07 10:57

I'm adding table rows dynamically and inside the cells for each row i'm adding a textbox,label and an imagebutton. I have event handler for the imagebutton click event and I would like to get the row of the clicked imagebutton so I can remove this row from the table.

Please good people, someone help!

Re: adding and removing table rows dynamically

Christian Graus27-Jul-07 11:30

Re: adding and removing table rows dynamically

27-Jul-07 11:30

You can work out which button was clicked in the event, and store the Id in the tag of the button.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

jojoStoneHead27-Jul-07 13:38

jojoStoneHead

27-Jul-07 13:38

Thanks, I managed to get hold of the row by getting the parent of the imagebutton and (the cell) and accessing the row through the cell.

BUT
I'm now having probblems with persisting the dynamically added rows after postbacks, any help please!!

Re: adding and removing table rows dynamically

Imran Khan Pathan27-Jul-07 23:24

Imran Khan Pathan

27-Jul-07 23:24

Hi there

I have done this type of work in my application.
I take one field in datatbase table to store row and cell no.
just like as "NoOfRow_NoOfColumn": 1_1,1_2,1_3,2_1,2_2,2_3.......
I have aslo take NoOfRow and NoOfColumn field to identify how many rows and column are there.

Now when I want to add new row,fisrt I take NoOfRow and increament it by 1 and looping trough NoOfColumn and Add New ROw.
Same thing for adding new Column.

Now In your case U just have to need to identify cell no.
If U have ImageButton on Every Each Row then give ROws Id to Image Button and pass it when click event fire and after that U can Delete selected rows.

Best Of Luck

Best Regard

Pathan

---------------------------------------------------

Adding a username/ password to http-post in a console application

rbreault27-Jul-07 10:39

rbreault

27-Jul-07 10:39

I have the following application, I need to supply a username and a password to perform my http-post and don't understand where to start with that can someone look at the following code and point me in the write direction or an example. Thank you

using System;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.Web;
using System.IO;
using System.Security.Cryptography.X509Certificates;

namespace postDT
{
class SimpleHttpClient
{

//private string GetPostdata()
//{
// string boundary = "boundary=---------------------------7d2e2c76e104be" + this._Boundary;
// int arrRegs = this._ParamsCollection.Count * 5;
// string[] auxReqBody = new string[arrRegs];
// int count = 0;
// foreach(ParamsStruct par in this.ParamsCollection)
// {
// auxReqBody[count] = boundary;
// count++;
// switch (par.Type)
// {
// case ParamsStruct.ParamType.File:
// {
// auxReqBody[count] = "Content-Disposition: file; name=\"" + par.Name + "\"; filename=\"" + par.GetOnlyFileName() + "\"";
// count++;
// auxReqBody[count] = "Content-Type: text/plain";
// count++;
// auxReqBody[count] = "";
// count++;
// auxReqBody[count] = par.StringValue;
// count++;
// break;
// }
// case ParamStruct.ParamType.Parameter:
// default:
// {
// auxReqBody[count] = "COntent-Disposition: form-data; name=\"" + par.Name + "\"";
// count++;
// auxReqBody[count] = "";
// count++;
// auxReqBody[count] = par.StringValue;
// count++;
// break;
// }
// }
// }
// auxReqBody[count] = boundary;
// count++;
// string requestBody = String.Join("\r\n",auxReqBody);
// return requestBody;
//}

[STAThread]
public static void Main(string[] args)
{
string gatewayUrl = "https://www.qa.dealertrack.com/DealerFeed/DealerFileUpload.asp";
string inputFilePath = "Z:/ZQ1412JPM/dealers.csv";
string DERCertFilePath = "C:/Documents and Settings/rbreault/Desktop/qa.dt.cer";
HttpWebResponse resp = null;

try
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(gatewayUrl);
Console.WriteLine("Connecting to URL: " + gatewayUrl);
// Read DER encoded client certificate and attach it to request object
// so it can be passed to the gateway as part of the SSL handshake
X509Certificate clientcert = X509Certificate.CreateFromCertFile(DERCertFilePath);
request.ClientCertificates.Add(clientcert);

// Read input from file
string inputData;
using (StreamReader inputFileReader = new StreamReader(inputFilePath))
{
inputData = inputFileReader.ReadToEnd();
}

Console.WriteLine("input file value:");
Console.WriteLine(inputData);

// encocde post data and set up the request NOTE: input data is passed as a parameter named 'boundry'
string postData = "boundry=---------------------------7d2e2c76e104be" + inputData + "-----------------------------7d2e2c76e104be--";
byte[] postDataBytes = Encoding.UTF8.GetBytes(postData);
request.Method = "POST";
request.ContentType = "multipart/form-data";
request.ContentLength = postDataBytes.Length;
Stream requestStream = request.GetRequestStream();
requestStream.Write(postDataBytes, 0 ,postDataBytes.Length);
requestStream.Close();

// get response and write to console
resp = (HttpWebResponse)request.GetResponse();
Console.WriteLine("Got a response from the file Gateway, response:");
StreamReader responseReader = new StreamReader(resp.GetResponseStream(), Encoding.UTF8);
Console.WriteLine(responseReader.ReadToEnd());

resp.Close();

}
catch(Exception e)
{
Console.WriteLine( e.ToString());
Console.WriteLine("\r\nThe request URI could not be found or was malformed");
}
finally
{
if ( resp != null )
{
resp.Close();
}
}
}
}
}

Re: Adding a username/ password to http-post in a console application

Paul Conrad27-Jul-07 19:41

Re: Adding a username/ password to http-post in a console application

27-Jul-07 19:41

What exactly is your problem?

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

rbreault27-Jul-07 19:43

rbreault

27-Jul-07 19:43

I get a 401 error. I need to pass a username and password but I am unsure where to add it to my code.

Re: Adding a username/ password to http-post in a console application

Paul Conrad27-Jul-07 19:49

27-Jul-07 19:49

Who did the website that you are trying to log to? You may want to direct your question to them, unless it was you that did the site Smile | :)

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Date formatting

Hasan Ali27-Jul-07 10:22

27-Jul-07 10:22

I have string = "5/8/2007 2:42:32.316425" got it from database
I want to convert it to .NET date object with all fraction second in it.

If any one knows Please let me know.

Thanks
Mohamed

Hasan Ali27-Jul-07 10:27

27-Jul-07 10:27

DateTime dta;
dta = Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy");

Hasan Ali27-Jul-07 10:45

27-Jul-07 10:45

DateTime dta;
dta = Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.ffffff"));
String ms = dta.Millisecond.ToString();

Hasan Ali27-Jul-07 10:51

27-Jul-07 10:51

DateTime dta;
dta = Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss.ffffff"));
String hhh = dta.ToString("MM/dd/yyyy HH:mm:ss.ffffff");
String ms = dta.Millisecond.ToString();

Paul Conrad27-Jul-07 10:40

27-Jul-07 10:40

Hasan Ali wrote:
with all fraction second in it

Elaborate a bit more, please...

Do you mean something like 5/8/2007 2:42:32 1/3"?

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Christian Graus27-Jul-07 14:22